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
>
>
>
>
>
>
>