An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations.
What do you recommend to minimize this?
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.