List:General Discussion« Previous MessageNext Message »
From:Yong Lee Date:September 11 2008 11:59pm
Subject:performance question
View as plain text  
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:    +1.604.418.4470

fax:         +1.604.273.8172

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

EQO ID:   yonglee

 

 

 

Attachment: [text/html]
Attachment: [text/html]
Attachment: [text/html]
Thread
performance questionYong Lee12 Sep
  • Re: performance questionwalter harms12 Sep