If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?

A.
Set SEQDETECT to NO.

B.
Set NUMBLOCKPAGES to 0 in all buffer pools.

C.
Allocate a block-based area in the appropriate buffer pool.

D.
Create indexes that encourage the optimizer to use index-only access.

Explanation: