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