集群因子概念

SQL> select count(distinct dbms_rowid.rowid_block_number(rowid)) from test where object_id<90;

COUNT(DISTINCTDBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID))
---------------------------------------------------
						  1

SQL> select count(distinct dbms_rowid.rowid_block_number(rowid)) from test where object_id<91;

COUNT(DISTINCTDBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID))
---------------------------------------------------
						  2


 

 
 
测试:
create table t1 as select trunc((rownum-1)/100) id,
                  rpad(rownum,100) t_pad
                  from dba_source
              where rownum<100000;
 
create index t1_idx1 on t1(id);
 
select a.column_name,
          b.num_rows,
           a.num_distinct Cardinality,
           round(a.num_distinct / b.num_rows * 100, 2) selectivity,
          a.histogram,
          a.num_buckets
      from dba_tab_col_statistics a, dba_tables b
     where a.owner = b.owner
       and a.table_name = b.table_name