Cluster Factor

select owner, table_name, column_name, num_distinct, last_analyzed from all_tab_col_statistics where owner in (‘EXAM1′,’TEST2′,’EXAMPLE2’); select * from all_part_col_statistics; select * from all_indexes; select * from sys.aux_stats\$; select owner, table_name, last_analyzed from all_tab_col_statistics where owner not in (‘SYS’,’PERFSTAT’,’DBSNMP’,’SYSTEM’,’SYSMAN’); select table_name, clustering_factor, num_rows from dba_indexes where table_owner in (‘SCHEMA_OWNER’) and clustering_factor > 0; select table_name, clustering_factor, num_rows from dba_indexes […]