本文探讨了当执行大量UPDATE、INSERT或DELETE操作时，为何表上的位图索引会导致性能下降。关键在于位图索引锁定的是位图段而非更小单位，这会增加锁竞争并降低性能。
201.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
Answer: C
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
