Re: sql tuning

Jonathan,

I have noted this effect as well. The clustering factors grow enormous, in several cases, and don't aks me how it does it, it has been greater than row count in the source table. A rebuild usually fixes the problem but it is still a problem in a 24X7 environment.

Mike Ault
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<amvp69$ngi$1$8300dec7_at_news.demon.co.uk>...
> Should be interesting to hear -
>
> I've just done a demo of how bitmap
> indexes degenerate under pressure from
> serial inserts on 9.2
>
> Under FL management the index grew
> from 8K to 45MB after a few thousand inserts.
>
> Under ASS Management, it grew to 600MB
> after a few hundred inserts.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____England______September 24/26, November 12/14
>
> ____USA__________November 7/9 (MI), 19/21 (TX)
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
>
>
>
> Richard Foote wrote in message ...
> >
> >Howard feels very strongly about ASSM, he absolutely loves it and considers
> >it one of the most significant advances in Oracle database technology ;)
> >
> >I sense a shovel load of 'horse manure' on it's way o:)
> >
Received on Sun Sep 29 2002 - 12:03:14 CDT