performance question

[Yong Lee]

All,
 
Just curious as to which query would be better in terms of performance:
 
select * from (select * from a union select * from b) as c;
 
versus
 
select * from a union select * from b;
 
or would these 2 queries be the same ?
 
Thanks,
Yong.
 

Yong Lee

Developer

ylee@stripped

 <http://www.eqo.com/> 

direct:      +1.604.273.8173 x113

mobile:    [phone]

fax:         [phone]

web:        www.EQO.com <http://www.eqo.com/> 

EQO ID:   yonglee

 

 

 

Attachment: [text/html]

Attachment: [text/html]

Attachment: [text/html]