I still believe CBO is better than RBO, but WTH?

From: Andy Johnson <AJohnson_at_Armature.com>
Date: Fri, 7 Sep 2001 15:55:46 +0100
Message-ID: <783866CAB183D211883F0090271F46C208670846@mailhost.armature.com>

Hi..

Have you tried looking into altering the OPTIMIZER_INDEX_CACHING, OPTIMIZER_INDEX_COST_ADJ as they can have a negative impact on some queries that worked fine in earlier versions of oracle, even when using RBO.. regards

andy

-----Original Message-----
From: nsouto_at_optushome.com.au.nospam (Nuno Souto) [mailto:nsouto_at_optushome.com.au.nospam]
Posted At: Friday, September 07, 2001 12:26 PM Posted To: server
Conversation: I still believe CBO is better than RBO, but WTH? Subject: Re: I still believe CBO is better than RBO, but WTH?

On Thu, 06 Sep 2001 21:00:03 +0200, Svend Jensen <svend_at_oraclecare.com> wrote:

>Statistics on one sample can prove anything. Pick your sample.

Uh? Which sample? I used "COMPUTE STATISTICS". That does the whole table.

>Anyway I find the cbo does the best job i most cases, and there are
>exceptions to the rule, then use it ;-)
>

Hmmmmmm. You don't use SAP or Peoplesoft, do you? :-)

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Fri Sep 07 2001 - 09:55:46 CDT