Oracle 数据库管理
-
编辑 删除
oracle 分析索引
SQL>analyze index index_name validate structure;SQL> SELECT blocks, pct_used, distinct_keys2 lf_rows, del_lf_rows3 FROM index_stats;BLOCKS PCT_USED LF_ROWS DEL_LF_ROWS------ --------- -------- ------------25 11 14 01 row selected.Reorganize the index if it has a high proportion of deleted rows, for example, when theratio of DEL_LF_ROWS to LF_ROWS exceeds 30%.LF_ROWS ：叶子数DEL_LF_ROWS：删除的叶子数要在同一个session中查看，否则看不见数据。[@more@]
