Re: Is a Union efficient?
On Tue, 14 Sep 1999 strangiato@my-deja.com wrote:
> Online 7.3x
>
> Is a UNION more efficient than separate SELECTs?
>
> Thanks!
>
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Use
SET EXPLAIN ON
SELECT .....<your select statement>
and you can find out. Set explain on writes out the query plan to a file
sqexplain.out in your current directory.
====================================================================
Harold Luse Phone: (970) 491-4120
Veterinary Teaching Hospital Fax: (970) 491-4123
Colorado State University Pager: (970) 229-8173
Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu
====================================================================