<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
iot表输出按主键列排序,heap表不是
最新推荐文章于 2021-04-12 13:54:56 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)