tag:blogger.com,1999:blog-23777397.post115526468172645833..comments2023-11-05T01:19:54.253-07:00Comments on Yet Another Oracle DBA: I am in for it nowHerod Thttp://www.blogger.com/profile/11276384892825160486noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-23777397.post-1155843863812580242006-08-17T12:44:00.000-07:002006-08-17T12:44:00.000-07:00Yes, I found out through the "grapevine" that they...Yes, I found out through the "grapevine" that they are rather concerned as they went ahead to prove me wrong and have ended up proving themselves wrong.<BR/><BR/>I will have my final stuff up on the blog before Monday.Herod Thttps://www.blogger.com/profile/11276384892825160486noreply@blogger.comtag:blogger.com,1999:blog-23777397.post-1155676943453666852006-08-15T14:22:00.000-07:002006-08-15T14:22:00.000-07:00Foote's demo of the threshold myth. (And some othe...<A HREF="http://groups.google.com/group/comp.databases.oracle.server/msg/96b20de9b49d2d6c" REL="nofollow">Foote's demo</A> of the threshold myth. (And some <A HREF="http://www.miracleas.dk/images/upload/Docs/Richard%20Foote.pdf" REL="nofollow">other useful</A> info.)<BR/><BR/>And there is a difference between plagiarism and scholarly discourse - attribution! :-)<BR/><BR/>Are you sure it's <I>punishment</I> for them to dress up in women's clothing? :-)Joel Garryhttps://www.blogger.com/profile/13325061229393838224noreply@blogger.comtag:blogger.com,1999:blog-23777397.post-1155521750473317782006-08-13T19:15:00.000-07:002006-08-13T19:15:00.000-07:00I think your biggest 'threat' to myth 1 is full in...I think your biggest 'threat' to myth 1 is full index scans. If all the required columns are in an index (and at least one is not null) then you'd probably get better performance from the index scan than the tablescan.<BR/>Of course that would mean that if you want all the columns, they would all need to be in the index in which case you maybe want a index-organised table.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-23777397.post-1155301342378890732006-08-11T06:02:00.000-07:002006-08-11T06:02:00.000-07:00I was only concerned with #1 because I couldn't re...I was only concerned with #1 because I couldn't remember where I had seen the debunking of it.<BR/><BR/>But I did find it in Tom's book last night so I am confident. <BR/><BR/>Myth #1 came out of a discussion about rules of thumb that if you are accessing a certain percentage of rows you must use a index.<BR/><BR/>The myth got percolated down to what I wrote.<BR/><BR/>I am pretty sure I can have all 3 of these written up and off to the soon to be public cross dressers before the weekend.<BR/><BR/>My manager left me a note that he has ordered 2 copies of Tom's newest book for the fellows.<BR/><BR/>I will have to make sure I don't plagiarize him exactly.Herod Thttps://www.blogger.com/profile/11276384892825160486noreply@blogger.com