What do you recommend to minimize this?

An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations.
What do you recommend to minimize this? (Choose the best answer)

An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations.
What do you recommend to minimize this? (Choose the best answer)

A.
Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache.

B.
Increase the size of the shared pool

C.
Configure the KEEP buffer cache and alter the tables to use the KEEP cache.

D.
Configure the RECYCLE buffer cache and alter the tables to use the RECYCLE cache.



Leave a Reply 2

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