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 -> stored outlines used but wrong plan executed

stored outlines used but wrong plan executed

From: Arik <arik_samson_at_excite.com>
Date: 16 Sep 2004 14:37:46 -0700
Message-ID: <699f12fe.0409161337.6ec7abec@posting.google.com> 





I wonder if anybody has stumbled upon the same problem:
Trying to optimize a query in version 9.2.0.4 with a stored outline. I
manipulated the outline to have the right hints, altered session to
use the outline, but when I run the query, although the outline is
used, the wrong plan is executed.



Thanks,


Arik
Received on Thu Sep 16 2004 - 16:37:46 CDT












Original text of this message













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