Re: Using bitmap indexes on Oracle 7.3

Not.

>
> The column will have only two values ( Y and N or something like it
 ) and
> will be heavily scanned and updated.
>

In the first case, bitmap indexes result in lots of locking contention when you update their columns.

In the second case a bitmap which limits your data returned by only a factor of 2 is not ON ITS OWN a particularly useful index, so the cost of the update contention is unlikely to outweigh the query benefit . Received on Sat Dec 13 1997 - 00:00:00 CST