A database named TEST was created and two buffer pools named BP_GENERAL and
BP_AUDITING were created as follows:

The majority of the database tables were created in table space TS1, while one large table was
created in table space TS2. A set of triggers thatThe majority of the database tables were created
in table space TS1, while one large table was created in table space TS2. A set of triggers that
would populate the table in table space TS2 each time changes were made to the database were
then defined and the database was put into production.
At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but
performance has gotten worse as the table has gotten larger. What should be done to improve
query performance?

A.
Reduce the size of the BP_AUDITING buffer pool.

B.
Increase the size of the BP_AUDITING buffer pool.

C.
Change the page size of the BP_AUDITING buffer pool to 16 or 32 K.

D.
Replace the BP_AUDITING buffer pool with a block-based buffer pool.

Explanation: