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 -> Re: Performance problem: anything else I can do to make this faster?

Re: Performance problem: anything else I can do to make this faster?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 02 Mar 2005 23:20:34 +0100
Message-ID: <00fc2196m32dguelv7p3uqbqbdla0unnvi@4ax.com> 





On 2 Mar 2005 13:30:52 -0800, nilendu_at_nilendu.com wrote:



>Try using an ORDERED hint after figuring out which is more selective.




The OP is using Rule Based Optimizer. Switching to CBO without doing
anything further is likely to end in disaster.



--
Sybrand Bakker, Senior Oracle DBA


Received on Wed Mar 02 2005 - 16:20:34 CST












Original text of this message













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