The Oracle AWR Unused Indexes Information screen

The Server Tools Oracle AWR Unused Indexes Information screen provides the means to generate and download a report that contains information on the following types of indexes:

  • Indexes that have no logical or physical reads
  • Indexes that are not found in query plans

The Oracle AWR Unused Indexes Information screen is available only if the database server is Oracle.

See also

Download an Oracle AWR unused indexes report

About this task

The Server Tools Oracle AWR Unused Indexes Information report contains information on indexes that have no logical or physical reads or indexes that are not found in query plans.

Procedure

  1. Log into Guidewire PolicyCenter using an administrative command.
  2. Navigate to the Server Tools Info Pages > Oracle AWR Unused Indexes Information screen.
  3. Set the options for the report.
  4. Select two database snapshots from the list at the bottom of the screen.

    Guidewire recommends that you select snapshots that have a wide range.

  5. Click Download.
  6. In the download dialog, set the download location.
  7. Click OK to download and save the report.
  8. Open the downloaded ZIP file and click index.html to open the index to the linked set of report files.