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 smallest amount of a bitmap that can be locked is a bitmap segment

B.
Additional time is taken to remove NULL values from the bitmap index after a DML operation

C.
The DML operations re-create the bitmap index blocks

D.
The bitmap index is rebuilt automatically after a DML operation



Leave a Reply 1

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


networkmanagers

networkmanagers

I choose A