分析索引是否变'坏'

使用以下语句验证索引
[@more@]-- 使用以下语句验证索引
-- 注意pct_used,如果小于used_space/btree_space-pct_free,考虑rebuild索引
-- An index can deteriorate over time due to sparseness, not due to "unbalancing".
analyze index validate structure
/
select btree_space, used_space, pct_used, blocks, lf_blks, br_blks from index_stats
/
ALTER INDEX COALESCE COMPUTE STATISTICS
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/6906/viewspace-779182/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/6906/viewspace-779182/