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

Question

Options

• ASet SEQDETECT to NO.
• BSet NUMBLOCKPAGES to 0 in all buffer pools.
• CAllocate a block-based area in the appropriate buffer pool.
• DCreate indexes that encourage the optimizer to use index-only access.

• A
  6% (3)
• B
  11% (6)
• C
  80% (43)
• D
  4% (2)

No community discussion yet for this question.