List:General Discussion« Previous MessageNext Message »
From:walter harms Date:September 12 2008 7:38am
Subject:Re: performance question
View as plain text  
you mail like to find it by your self. simply use : explain <query>

re,
  wh

Yong Lee schrieb:
> 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
> 
>  
> 
>  
> 
>  
> 
Thread
performance questionYong Lee12 Sep
  • Re: performance questionwalter harms12 Sep