RE: RULE versus CHOOSE - sorry it's long

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Mon, 09 Jul 2001 05:41:29 -0700
Message-ID: <F001.0034433F.20010709054549@fatcity.com>

Thank you for correcting me Jared.

Lisa

-----Original Message-----

From:   Jared Still [SMTP:jkstill_at_cybcon.com]
Sent:   Friday, July 06, 2001 11:36 PM
To:     ORACLE-L_at_fatcity.com; Koivu, Lisa

Subject:        Re: RULE versus CHOOSE - sorry it's long

On Friday 06 July 2001 06:41, Koivu, Lisa wrote:

>       Choose invokes the cost based optimizer (CBO).  If the
> optimizer_goal = RULE, it is rule, period (RBO).

Not true Lisa.

Try setting parallel degree > 1 on a table, do an explain plan on a SELECT and see what happens.

Certain operations require CBO, and CBO will be invoked regardless of the CHOOSE setting.

Jared Received on Mon Jul 09 2001 - 07:41:29 CDT