iot表输出按主键列排序,heap表不是

<pre name="code" class="html"> create table t1  (id char(10) primary key,a1 char(10),a2 char(10));  


begin 
for i in 1 .. 1000
loop 
insert into t1 values(i,i,'a'||i); 
end loop 
; 
commit; 
end; 


BEGIN
  DBMS_STATS.GATHER_TABLE_STATS(ownname          => 'TEST',
                                tabname          => 'T1',
                                estimate_percent => 100,
                                method_opt       => 'for all columns size repeat',
                                no_invalidate    => FALSE,
                                degree           => 8,
                                cascade          => TRUE);
END;
/ 




create