Re: Odd, Rulebased query improves with statistics!!?

By any chance are you running Parallel Query? PQ will not use Rule and will force CBO regardless of hint, init.ora setting. In you *are* then I'd seriously recommend analyzing ALL of your application tables that have a degree set, otherwise when CBO runs, it will take some pretty nasty default stats...

--Roby

Yurasis Dragon wrote:

> Has anyone had the experience of having a query with a RULE hint
> improve as the result of tables being analyzed? We have had a query
> improve from 1 min. 36 secs. run time to 6 seconds by analyzing the
> tables in the query. I don't get it.
>
> Anyone similar else with similar experiences? By the way, we're using
> 7.3.4 in Solaris 2.5 and 8.0.5 and Digital Unix (can't remember the
> version).
>
> Thanks in advance for any comments.
>
> ===
>
> Yurasis Dragon
> yurasis_dragonNOSPAM_at_yahoo.com
> (remove NOSPAM to reply)
Received on Sat Mar 25 2000 - 00:00:00 CST