暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
Oracle B-Tree Index Internals.pdf
76
166页
3次
2024-09-22
免费下载
Oracle B-Tree Index Internals:
Rebuilding The Truth
Richard Foote
Richard Foote - Index Internals 1
Objectives
Dispel many myths associated with Oracle B-Tree
Indexes
Explain how to investigate index internals
Explain and prove how Oracle B-Tree Indexes work
Explain when index rebuilds might be appropriate
Richard Foote - Index Internals 2
“Expertquotes 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
of 166
免费下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。