注册 登录
编程论坛 Oracle论坛

SQL性能求教

心动音符 发布于 2007-12-09 20:47, 1654 次点击
写法一:
create table A as
select * from B
;
Create table C as
select a.*,d.*
from D as d
left join A as a on (a.id = d.id)
;
写法二:
Create table C as
select a.*,d.*
from D as d
left join (select * from B) as a
on (a.id = d.id)
;

这两种写法哪种比较快
1 回复
#2
ILoveMK2007-12-10 13:28
第二种快点。
1