Oracle 多表连接顺序与性能关系测试
本文导语: 一. 创建表并insert 数据 create table ta (id number,name varchar2(10)); create table tb(id number,job varchar2(10)); begin for i in 1..1000000 loop begin insert into ta values(i,'dave'); commit; end; end loop; end; begin for i in 1..1000000 loop begin if i select /*+rule*/ta.id, ta.name,...
一. 创建表并insert 数据
create table ta (id number,name varchar2(10));
create table tb(id number,job varchar2(10));
begin
for i in 1..1000000 loop
begin
insert into ta values(i,'dave');
commit;
end;
end loop;
end;
begin
for i in 1..1000000 loop
begin
if i select /*+rule*/ta.id, ta.name,tb.job from ta,tb where ta.id