Re: Cost versus Rule based Optimizer

[Quoted] Once I analyzed all tables of my database and had a huge drop in performance.
I deleted the analyzed information of schema SYS and my performance was [Quoted] better then ever.

Is the app developed for cost based or rule based ? Are there any hints in the SQL?

Michiel

[Quoted] Aamer wrote in message <37E89431.5BA7DBBB_at_hotmail.com>...
>Hi All
>
>On checking the database it was found that the tables and schemas where
>not analysed. So in fact it was using rule based optimisation. We
>immediately analysed all schemas .
> After analysing The buffer hit ratio which was 95% dropped to 84%
>and the sort in disk increased from 0.5% to 15%.
>
>Once we deleted the analysing information it improved the buffer hit
>ratio to 94% and sort on disk to 6% .
>
> Its not understood why when we analysed the buffer hit ration
>dropped.
>
> Aamer_janjua_at_hotmail.com
>
> Thanks
Received on Wed Sep 22 1999 - 15:17:19 CEST