Re: Bitmap indexes cause slow load

From: Peter L <news_at_abc.co.uk>
Date: Sat, 12 May 2001 21:01:54 GMT
Message-ID: <3afda478.21721190@news.freeserve.net>

On Fri, 11 May 2001 23:31:07 GMT, nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) wrote:

>
>As such, I'd expect to see more than just one bitmap index in this
>case. One only disturbs me. Maybe a b-tree would be a better choice?
>Or didn't we get the whole story?
>

The original message included this paragraph, towards the end, that implies several bitmap indexes are involved.

>

Dropping and recreating the index is not an alternative because creating the index takes about 20 minutes and we have about 10 columns that need the query performance gains of a bitmap.
>
Received on Sat May 12 2001 - 16:01:54 CDT