
“Expert” quotes regarding Indexes
• “Note that Oracle indexes will spawn to a fourth
level only in areas of the index where a massive
insert has occurred, such that 99% of the index
has three levels, but the index is reported as
having four levels. ” Don Burleson:
comp.databases.oracle.server newsgroup post
dated 31st January 2003
• “If the index clustering factor is high, an index
rebuild may be beneficial”. Don Burleson: Inside
Oracle Indexing dated December 2003 at
www.DBAzine.com
Richard Foote - Index Internals 3
相关文档
评论