SQL性能求教

心动音符

高级会员

Rank: 4

帖子: 826
精华: 1
性别: 男
注册时间: 2005-9-15

1^# 大中小发表于 2007-12-9 20:47 只看该作者

SQL性能求教

写法一：
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)
;

这两种写法哪种比较快

搜索更多相关主题的帖子: SQL table select 性能