Hi Chad

You can get some performance problems when you ...

Use the Union to create a View

Then join that View to other tables in some queries. Otherwise they
work great.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Chad Z. Hower wrote:

>:: Select xxxx from yyyy
>:: Union
>:: Select wwww from zzzz
>::
>:: I presume that it is what you meant because there is no
>:: point otherwise. Both sections of the query can be optimised
>:: separately, so it should be fine.
>
>Yes, different tables. Sorry. :)
>
>:: would be a bad idea if there is no index on Name.
>
>Yes. I was just curious if running the two as a union, vs running them
>separately and tallying details in the client will cause any optimization or
>other problems.
>
>
>