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
Received on Fri Jan 09 2004 - 21:47:45 CST
