Re: Help! Bitmap Index

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 28 Apr 1999 23:38:21 +0100
Message-ID: <37278DDD.4591AA1C@rdbms.freeserve.co.uk>

Alon,

We use bitmaps extensively within our DSS environment and get excellent performance increases. I'm surprised that your query hasn't improved in response time as the bitmap index will take less space than an equivalent btree.

Might be worth taking this off line and emailing me the query and statistics before and after the bitmap.

Chris.

Alon Peled wrote:
>
> Hi,
>
> I have created a bitmap index on the sex column (M/F Values) and
> performance during queries on this column has not been changed.
> The table is 3M in size and tkprof shows that the index is being used.
> Has any one used Bitmap index and got any performance increase?
>
> Thanks
> Alon Peled
> www.peled.com
Received on Wed Apr 28 1999 - 17:38:21 CDT