Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bitmap index performance
FYI,
I just changed the initora parameter bitmap_merge_area_size from 1mb to 6mb
and one of my benchmark queries went from 4 minutes to 30 seconds.
The index definitions are extemely large. I am using partition tables.
These are local indexes. Right now I have 30 partitions for this table.
Jonathan Lewis wrote in message
<921947096.5959.0.nnrp-06.9e984b29_at_news.demon.co.uk>...
>It would be useful to see the index definitions and
>the execution plans.
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
Received on Sat Mar 20 1999 - 11:56:05 CST