Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

Why does performance degrade when many UPDATE, INSERT or DELETE statements are

issued on a table that has an associated bitmap index?

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



Leave a Reply 5

Your email address will not be published. Required fields are marked *


KUMAR

KUMAR

The Answer is C

C. The smallest amount of a bitmap that can be locked is a bitmap segment

the king

the king

can somebody please explain this further.

ELIJAH

ELIJAH

whats the explanation

bf

bf

because when DML excute in the database , the row that have the same value will be locked.