Re: optimizer_mode = choose ??

From: Lee E Parsons <lparsons_at_world.std.com>
Date: Tue, 4 Oct 1994 13:38:52 GMT
Message-ID: <Cx5Hwt.580_at_world.std.com>


jp_at_vllyoak.resun.com (Jeff Perry) writes:
>
>The V7 Oracle Admin manual indicates two possible settings for the
>OPTIMIZER_MODE parameter: RULE & COST. Our databases don't have
>this parameter specifically set, and a query of the v$sysstat view
>indicates optimizer_mode = CHOOSE. What kind of optimization takes
>place with such a setting?

The manual is wrong. The COST keyword has been replaced by CHOOSE. Why Oracle would screwup the printed Docs just to make such a trivial change is another valid question. But I'll save it for another day. :-}

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com
Received on Tue Oct 04 1994 - 14:38:52 CET

Original text of this message