A database administrator completed a significant project to create appropriate indexes for an
application. The administrator needs to see if there are any indexes the Query Engine is calling for
which have not already been created.
How can the administrator ensure that only the new index requests will be shown in the Index
Advisor panel?

A.
In QUSRSYS, clear the first member of QENUSRTBL table.

B.
In System i Navigator> Database > SQL Plan Cache > Clear All.

C.
Copy the first member of SYSIBM/REE_CST1 into a saved member and clear the member.

D.
Right click on Database > Index Advisor> Index Advisor> Clear All Advised Indexes.