Re: How do you un-analyze tables?

OK I panicked......
I know how to un-analyze the objects.
but why does't it choose RULE when it's so much faster. George Barbour.

"George Barbour" <george.barbour_at_gecm.com> wrote in message 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 Thu Jun 28 2001 - 09:13:49 CDT