玉面飞龙的BLOG

B-Tree Index Internals: Rebuilding The Truth

September 4th, 2008 | Categories: Boring | Tags: Index, Oracle

似乎是Richard2007年12月份新总结的文档。非常不错，对过去的Index Internal作了完善和补充。itpub这里有下载。

以下内容都非常好:

1) freelist&freelist group and ASSM will make worse cluster_factor: if there is not freelist contention,don’t need to increase it.
2) analyze index validate structure is not suitable in online active table & big indexes.
3) bug 3196414 of 50-50 index plit during loop insert-commit has been fixed in 10g.
4) The redo generated by the Coalesce operation is vastly more than that of the rebuild sometimes
5) index range scan could use db file scatter read to warm db_cache in 10g just after database is re-started
6) build index online still need locks on table in 10g. but don’t need in 11g.

政治不稳定；经济不景气，我还是多多学习老本行的好。

最好上海能够调整个人所得税起正点到1w。