Re: Union problem
Date: Sat, 19 Dec 1998 13:15:26 +0100
Message-ID: <75g5d3$t4$1_at_newsreader.global-one.nl>
This kind of union will give you a distinct result st. If your source tables
are very big this could take some time.
Try using "union all" if you don't care about duplicates or if your tables
don't contain dupes.
G'luck,
Andrew Hendrickson wrote in message ...
Gabri
>To all,
>
>I have a construct of :
>
>select a from x
>union
>select a from y
>
>The above query runs for around a couple of hours. When I stub out either
>one of the queries it runs in seconds. Any clues? I am using this in
>reports designer however the test script is running in PL/SQL. This seems
>to be the pertinent information but if any thing else is needed let me
know.
>
>I am in a crunch and need these queries running quickly very soon.
>TIA
>Andy
>
>
Received on Sat Dec 19 1998 - 13:15:26 CET