Re: Growth of Local Partitioned Bitmap Indexes

From: Bricklen <Xbricklen_at_yahoo.comX>
Date: Sat, 10 Jan 2004 04:17:09 GMT
Message-ID: <91LLb.41975$ts4.7891@pd7tw3no>

Domenic G. wrote:

> Excellent article. I agree with it, but let's put this into a real
> world situation -- a table with let's say a fixed number of statuses
> -- financial status codes -- let's say 10, that a record goes through
> during its lifecycle. Even though we frequently search on that
> status, I would not bitmap it because of the contention issue. Other
> processes are going to want flip the status many times and that will
> lock out the others (for a while anyway). That was my original point.
> I find them useful only on read only materialized views. I did learn
> a lot from that article. Thanks!!
>
> Bricklen <bricklen-rem_at_yahoo.comz> wrote in message news:<9OCLb.20$De.16_at_edtnps84>...
>

>>Domenic G. wrote:
>>
>>
>>>Any change in the from or to value will lock them all -- test it.
>>
>>                                                          ^^^^^^^^^^
>>I think maybe he already has:
>>http://www.dbazine.com/jlewis3.html

Don't thank me! Thank the dedicated dbas/scientists who write and prove their material time and time again, in articles like that and even here in these newsgroups.

Cheers,

Bricklen Received on Fri Jan 09 2004 - 22:17:09 CST