標(biāo)題: 大數(shù)據(jù)量插入測(cè)試 [打印本頁(yè)] 作者: imtj 時(shí)間: 2008-06-18 11:38 標(biāo)題: 大數(shù)據(jù)量插入測(cè)試 reate table test7(id number(10),hire_date date);
create index test7_indx on test7(id);
alter table test7 nologging ;
declare
i int;
begin
for i in 1..600000 loop
insert into test7 values (i,sysdate);
end loop;
end;
需要190秒
create table test8(id number(10),hire_date date)
create index test8_indx on test7(id)
alter table test7 nologging;
alter index test7_indx nologging;
declare
i int;
begin
for i in 1..600000 loop
insert into test8 values (i,sysdate);
end loop;
end;
需要148秒
create table test9(id number(10),hire_date date)
alter table test9 nologging;
declare
i int;
begin
for i in 1..600000 loop
insert into test9 values (i,sysdate);
end loop;
end;
需要75秒
create table test10(id number(10),hire_date date)
declare
i int;
begin
for i in 1..600000 loop
insert into test10 values (i,sysdate);
end loop;
end;
需要81秒
create table test11(id number(10),hire_date date);
alter table test11 nologging;
declare
i int;
begin
for i in 1..600000 loop
insert /+* APPAND +/ into test11 values (i,sysdate);
end loop;
end;
需要69秒