Re: Bitmap index performance

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 20 Mar 1999 18:33:05 -0000
Message-ID: <921952846.4405.0.nnrp-13.9e984b29@news.demon.co.uk>

I meant the columns, not the physical storage.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Lee Miller wrote in message ...
>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.
Received on Sat Mar 20 1999 - 12:33:05 CST