VIEW: SYS.CDB_IND_STATISTICS

Source

View Text - Preformatted

SELECT "OWNER","INDEX_NAME","TABLE_OWNER","TABLE_NAME","PARTITION_NAME","PARTITION_POSITION","SUBPARTITION_NAME","SUBPARTITION_POSITION","OBJECT_TYPE","BLEVEL","LEAF_BLOCKS","DISTINCT_KEYS","AVG_LEAF_BLOCKS_PER_KEY","AVG_DATA_BLOCKS_PER_KEY","CLUSTERING_FACTOR","NUM_ROWS","AVG_CACHED_BLOCKS","AVG_CACHE_HIT_RATIO","SAMPLE_SIZE","LAST_ANALYZED","GLOBAL_STATS","USER_STATS","STATTYPE_LOCKED","STALE_STATS","SCOPE","CON_ID" FROM CONTAINERS("SYS"."DBA_IND_STATISTICS")

View Text - HTML Formatted

SELECT "OWNER"
, "INDEX_NAME"
, "TABLE_OWNER"
, "TABLE_NAME"
, "PARTITION_NAME"
, "PARTITION_POSITION"
, "SUBPARTITION_NAME"
, "SUBPARTITION_POSITION"
, "OBJECT_TYPE"
, "BLEVEL"
, "LEAF_BLOCKS"
, "DISTINCT_KEYS"
, "AVG_LEAF_BLOCKS_PER_KEY"
, "AVG_DATA_BLOCKS_PER_KEY"
, "CLUSTERING_FACTOR"
, "NUM_ROWS"
, "AVG_CACHED_BLOCKS"
, "AVG_CACHE_HIT_RATIO"
, "SAMPLE_SIZE"
, "LAST_ANALYZED"
, "GLOBAL_STATS"
, "USER_STATS"
, "STATTYPE_LOCKED"
, "STALE_STATS"
, "SCOPE"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_IND_STATISTICS")