iot表测试:
在create table语句后面使用organization index,就指定数据表创建结构是IOT。但是在不指定主键Primary Key的情况下,是不允许建表的。
create table t100 (id int primary key,a1 char(10),a2 char(10))organization index;
SQL> select object_name,object_id from user_objects;
OBJECT_NAME OBJECT_ID
-------------------------------------------------------------------------------------------------------------------------------- ----------
SYS_IOT_TOP_102692 102693
T100 102692
begin
for i in 1 .. 1000
loop
insert into t100 values(i,'a'||i,'b'||i);
end loop
;
commit;
end;
BEGIN
DBMS_STATS.GATHER_TABLE_STATS(ownname => 'SCAN',
tabname => 'T100',
estimate_percent => 100,
method_opt => 'for all columns size repeat',
iot 表索引dump《2》
最新推荐文章于 2016-11-08 09:36:00 发布