[Oracle] Oracle中检查是否需要重构索引的sql

SELECT 
height, /*Height of the B-Tree*/ 
blocks, /* Blocks in the index segment */ 
name, /*index name */ 
lf_rows, /* number of leaf rows in the index */ 
lf_blks, /* number of leaf blocks in the index */ 
del_lf_rows, /* number of deleted leaf rows in the index */ 
rows_per_key /* average number of rows per distinct key */ 
blk_gets_per_access /* consistent mode block reads (gets) */ 
FROM INDEX_STATS 
WHERE NAME='INDEX_NAME';

ANALYZE index INDEX_NAME VALIDATE STRUCTURE