Re: Tx lock problem with bitmap index

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 18 Dec 2002 21:40:50 -0000
Message-ID: <3e00ec97_1@mk-nntp-1.news.uk.worldonline.com>

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:atq758$a6m$2$8300dec7_at_news.demon.co.uk...
>
> I suggest you look at my article on
> www.dbazine.com about bitmap indexes
> for a detailed explanation of what you are
> seeing.
>
> Bottom line - you don't do single row
> processing with bitmap indexes in place,
> and you don't do concurrent processing
> with bitmap indexes in place.
>
> To split hairs - it's not a limitation, it's
> a restriction. (i.e. It's not a problem by
> accident, it's a necessary implementation
> detail of the feature).
>

In other words, don't use them unless this is a DW being rebuilt overnight?

Regards,
Paul Received on Wed Dec 18 2002 - 15:40:50 CST