Re: Oracle 9i - switching to rule based optimizer optimizer

pheimill_at_netscape.net wrote:

> In 8i, if the init.ora initialization parameter optimizer_goal=choose
> was set, then removing statistics would cause oracle to use the rule
> based optimizer. Does anyone know if 9i works the same way? We would
> like to try out the rule based optimizer during some testing, but
> don't want to effect others on the same instance.

Yes and don't.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)