Oracle Open World 2009 Report - Part Two
Tuesday October 13th
Unconference on IndexesRichard Foote10/13/2009 10:00 AM
I started off the day attending the indexing presentation of fellow Oak Table member Richard Foote. Foote has become quite well known for his expertise on index internals since the publication of Oracle B-Tree Index Internals: Rebuilding the Truth
This was basically a Q&A session, and I will include just a couple of the questions.
Q: Have you ever seen an index Skip Scan used correctly?A: The short answer was ‘No’
Foote mentioned that he had only rarely seen an index skip scan used, and then inappropriately. For more information on skip scan, see Foote’s blog entry
…click on the title to read the full article…
Leave a Reply