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>
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.comReceived on Tue Oct 04 1994 - 14:38:52 CET