Hakanfactor(三)
wnum<64;
已创建 63 行。
SQL> commit;
提交完成。
SQL> alter table t1 minimize records_per_block;
表已更改。
SQL> execute show_hakan('t1');
Hakan factor for object 78156 (EASY.t1) is 62 with flags 8000
PL/SQL 过程已成功完成。
select
ct, count(*)
from (
Select Dbms_Rowid.Rowid_Block_Number(Rowid), Count(*) Ct
from t1
group by
dbms_rowid.rowid_block_number(rowid)
)
Group By Ct
10 order by ct
11 /
CT COUNT(*)
---------- ----------
3 16384
63 1
SQL> create bitmap index i1 on t1(c1);
索引已创建。
SQL>
create bitmap index i2 on t2(c1);
索引已创建。
SQL> select segment_name,blocks from user_segments where segment_name like 'I%';
SEGMENT_NAME BLOCKS
--------------------------------------------------------------------------------- ----------
I1 16
I2 8
SQL> insert into t2 select * from t2 where rownum<64;
已创建 63 行。
SQL> commit;
提交完成。
SQL> select segment_name,blocks from user_segments where segment_name like 'I%';
SEGMENT_NAME BLOCKS
--------------------------------------------------------------------------------- ----------
I1 16
I2 8