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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |