DBA_IND_STATISTICS
DBA_IND_STATISTICSの仕様

索引のオプティマイザ統計情報

 名前                                                NULL?    型
 ----------------------------------------------------- -------- ------------------------------------
 OWNER                                                          VARCHAR2(30)
 INDEX_NAME                                                     VARCHAR2(30)
 TABLE_OWNER                                                    VARCHAR2(30)
 TABLE_NAME                                                     VARCHAR2(30)
 PARTITION_NAME                                                 VARCHAR2(30)
 PARTITION_POSITION                                             NUMBER
 SUBPARTITION_NAME                                              VARCHAR2(30)
 SUBPARTITION_POSITION                                          NUMBER
 OBJECT_TYPE                                                    VARCHAR2(12)
 BLEVEL                                                         NUMBER
 LEAF_BLOCKS                                                    NUMBER
 DISTINCT_KEYS                                                  NUMBER
 AVG_LEAF_BLOCKS_PER_KEY                                        NUMBER
 AVG_DATA_BLOCKS_PER_KEY                                        NUMBER
 CLUSTERING_FACTOR                                              NUMBER
 NUM_ROWS                                                       NUMBER
 AVG_CACHED_BLOCKS                                              NUMBER
 AVG_CACHE_HIT_RATIO                                            NUMBER
 SAMPLE_SIZE                                                    NUMBER
 LAST_ANALYZED                                                  DATE
 GLOBAL_STATS                                                   VARCHAR2(3)
 USER_STATS                                                     VARCHAR2(3)
 STATTYPE_LOCKED                                                VARCHAR2(5)
 STALE_STATS                                                    VARCHAR2(3)
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License