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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Union all very slow.

Re: Union all very slow.

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 25 Oct 2006 13:40:10 -0500
Message-ID: <de807caa0610251140n26b95caao5b18ae7d361603fe@mail.gmail.com> 





Randy,



I'd start by doing an EXPLAIN PLAN on each part and the whole thing. You
didn't mention your Oracle version, but maybe the CBO is getting smart
enough to optimize the entire query, so is making a bad decision.



Dennis Williams


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Oct 25 2006 - 13:40:10 CDT












Original text of this message













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