INDEX_STATS
INDEX_STATSの仕様

前回のANALYZE INDEX … VALIDATE STRUCTURE文の情報を示す。

 名前                                                NULL?    型
 ----------------------------------------------------- -------- ------------------------------------
 HEIGHT                                                         NUMBER
 BLOCKS                                                         NUMBER
 NAME                                                           VARCHAR2(30)
 PARTITION_NAME                                                 VARCHAR2(30)
 LF_ROWS                                                        NUMBER
 LF_BLKS                                                        NUMBER
 LF_ROWS_LEN                                                    NUMBER
 LF_BLK_LEN                                                     NUMBER
 BR_ROWS                                                        NUMBER
 BR_BLKS                                                        NUMBER
 BR_ROWS_LEN                                                    NUMBER
 BR_BLK_LEN                                                     NUMBER
 DEL_LF_ROWS                                                    NUMBER
 DEL_LF_ROWS_LEN                                                NUMBER
 DISTINCT_KEYS                                                  NUMBER
 MOST_REPEATED_KEY                                              NUMBER
 BTREE_SPACE                                                    NUMBER
 USED_SPACE                                                     NUMBER
 PCT_USED                                                       NUMBER
 ROWS_PER_KEY                                                   NUMBER
 BLKS_GETS_PER_ACCESS                                           NUMBER
 PRE_ROWS                                                       NUMBER
 PRE_ROWS_LEN                                                   NUMBER
 OPT_CMPR_COUNT                                                 NUMBER
 OPT_CMPR_PCTSAVE                                               NUMBER
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License