Re: sql tuning

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 26 Sep 2002 21:03:30 +0100
Message-ID: <amvp69$ngi$1$8300dec7@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 Thu Sep 26 2002 - 15:03:30 CDT