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

[EMAIL PROTECTED]

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

direct:      +1.604.273.8173 x113

mobile:    +1.604.418.4470

fax:         +1.604.273.8172

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

EQO ID:   yonglee