- use : analyze your_table delete statistics;
- sorry
"George Barbour" <george.barbour_at_gecm.com> schrieb im Newsbeitrag
news:3b3b2c17$1_at_pull.gecm.com...
> Hi all,
> Oracle 8.1.5.
> Sun Solaris Unix 2.8.
> The situation, I have many Oracle Discoverer queries against the database.
> Some queries run as RULE and some ran as COST.
> I analyzed the objects, mistake! Now all of the queries run as COST. The
> difference in run time is spectacular.
> Rule based = 17.9 secs.
> Cost based = 388 mins.
>
> 1) How to I un-analyze objects, to get back to where I was before?
> 2) Why doesn't the system use the blatantly faster optimisation mode?
>
> George Barbour.
> .
>
>
>
>
>
>
>
Received on Mon Jul 02 2001 - 07:50:17 CDT
