Re: UNION: SQL-tuning

Andrei Romazanov wrote:
>
> Hello all,
>
> I have performance-problem in a UNION.
> Normally I can separated optimize the parts from UNION,
> in this case however show both part-SELECTS good performance,
> but in UNION suddenly appears FULL TABLE SCAN. Could someone explain to me
> this
> behavior of the Optimizer?
>
> Thank you in advance
>
> Andrei

Can you use UNION ALL - its far more efficient (if applicable)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."