Re: Rule versus Cost Based Optimizer Issue on Oracle 7.1

In article: <rp1399-1606950847270001_at_m12cim15.sps.mot.com> rp1399_at_email.sps.mot.com (Steve Lemme) writes:
>
> 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
>
>

  With the following

ORACLE>analyze table emp estimate statistics sample 10 percent;

Table analyzed.

ORACLE>analyze table emp estimate statistics sample 10 rows;

Table analyzed.  

	Come, let us retract the foreskin of ignorance, and apply the
	wirebrush of enlightenment

	Tim London			phone :	+44 1753 662393
	Oracle DBA,Trainer and		mobile:	+44 836 287064
	part time OU tutor		Email : tim_at_artemis.demon.co.uk
----------------------------------------------------------------------------