ANALYZE INDEX clause

Oracle Database collects the following statistics for an index. Statistics
marked with an asterisk are always computed exactly. For conventional indexes,
when you compute or estimate statistics, the statistics appear in the data
dictionary views USER_INDEXES,ALL_INDEXES, and DBA_INDEXES in the columns shown
in parentheses.
■ * Depth of the index from its root block to its leaf blocks (BLEVEL)
■ Number of leaf blocks (LEAF_BLOCKS)
■ Number of distinct index values (DISTINCT_KEYS)
■ Average number of leaf blocks for each index value (AVG_LEAF_BLOCKS_PER_KEY)
■ Average number of data blocks for each index value (for an index on a table)
(AVG_DATA_BLOCKS_PER_KEY)
■ Clustering factor (how well ordered the rows are about the indexed values)
(CLUSTERING_FACTOR)

使用ANALYZE INDEX 分析索引的root塊至葉子塊的深度 ，葉子塊數目 ， distinct索引值 等資訊 ，將分析資料儲存在*INDEXES等檢視的BLEVEL,LEAF_BLOCKS等欄位

[@more@]