Re: Rule versus Cost Based Optimizer Issue on Oracle 7.1

How did you bump up the default sampling rate?

Thanks
Steve

In article <DA8svJ.IAq_at_eskimo.com>, lparsons_at_eskimo.com (Lee Parsons) wrote:

>
> I just had a ton of trouble with the 7.1.3 cost based optimizer until
> I realized that the estimate statistics command uses an insanely small
> default sampling rate. Once I bumped it up every thing worked great.
>
> --
> Regards,
>
> Lee E. Parsons
> Systems Oracle DBA lparsons_at_world.std.com
 

-- 
When you are in it up to your ears....
Keep your mouth shut!
rp1399_at_email.sps.mot.com