Why does performance degrade when many UPDATE, INSERT or DELETE statements are
issued on a table that has an associated bitmap index?
A.
The DML operations re-create the bitmap index blocks
B.
The bitmap index is rebuilt automatically after a DML operation
C.
The smallest amount of a bitmap that can be locked is a bitmap segment
D.
Additional time is taken to remove NULL values from the bitmap index after a DML operation
The Answer is C
C. The smallest amount of a bitmap that can be locked is a bitmap segment
can somebody please explain this further.
whats the explanation
Why?
because when DML excute in the database , the row that have the same value will be locked.