Re: Rule versus Cost Based Optimizer Issue on Oracle 7.1

Jfruetel <jfruetel_at_aol.com> wrote:
>To a large extent, we normally use rule based optimization. I haven't
>experimented with 7.1 yet, but at least in 7.0, we were pretty
>consistently able to beat the cost-based optimizer by tuning our queries
>by hand and using rule-based optimization (actually, it was more like
>hand-optimization).
>
>Does anyone know if the 7.1 cost-based optimizer works any better than the
>7.0 version?

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