Re: Help needed with slow union join

From: Stephen Reid <stephen.reid_at_NOSPAMttabconnectors.com>
Date: Thu, 1 Jun 2006 08:23:27 +0100
Message-ID: <447e95dc$0$15927$da0feed9@news.zen.co.uk>

Thanks for all the replies. This is what I had done and it the example count(*) query no takes just a few seconds. I am yet to test how much of an impact this has had on the actual queries.

Thanks again
Stephen
"Vince" <vinnyop_at_yahoo.com> wrote in message news:1149088154.396500.13770_at_c74g2000cwc.googlegroups.com...
> If there is no overlap in the data between the 2 selects, try using
> UNION ALL instead of UNION.
>
Received on Thu Jun 01 2006 - 02:23:27 CDT