Thank you for correcting me Jared.
Lisa
-----Original Message-----
From: Jared Still [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 11:36 PM
To: [EMAIL PROTECTED]; 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
