Re: Bitmap index performance

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 20 Mar 1999 16:23:57 -0000
Message-ID: <921947096.5959.0.nnrp-06.9e984b29@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

Lee Miller wrote in message <#VQeGmuc#GA.115_at_upnetnews02.moswest.msn.net>...
>Hello, I recently ran a test comparing queries that have bitmap indexes on
>multi-million row table and then converting them back to non-bitmap
indexes.
>The columns seemed to be good candidates for bitmap (ie. year_month, also
>another on brand). However, I noticed that the query performance was
pretty
>much identical. I reviewed the query plans and confirmed that the indexes
>were indeed being used. We are using 8.0.4.1 on HPUX. Are there specific
>initora parameters that I should review?
Received on Sat Mar 20 1999 - 10:23:57 CST