5.13.6 Viewing Top SQL Page

Use the Top SQL page to identify poorly performing SQL.

To view the Top SQL page:

1. On the Workspace home page, click the SQL Workshop.
2. Click Utilities.
3. Click Database Monitor.
4. Click Top SQL.
5. If prompted, enter the appropriate administrator user name and password and click Login.

   The Top SQL page appears. Use the search fields and lists and the top of the page and click Go to narrow the display. For details on each field or list, click the label.

6. To access the SQL Plan page, click the View icon.

   The SQL Plan page appears, containing the following sections:

   • Query Plan - Contains a color coded explain plan. Note that unindexed columns display in red.

   • SQL Text - Displays the full text of the SQL statement.

   • Indexes - Displays all indexes on the table in the query. There is a checkmark when that index is used in the query.

   • Table Columns - Shows all columns on all tables or views in the query.