Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> UNION: SQL-tuning

UNION: SQL-tuning

From: Andrei Romazanov <romazanov.andrei_at_gfos.de>
Date: Thu, 12 Sep 2002 08:52:25 +0200
Message-ID: <alpddu$1rt0js$1@ID-70985.news.dfncis.de> 






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
Received on Thu Sep 12 2002 - 01:52:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US