About Top SQL

The "top" SQL statements represent the SQL statements that are executed most often, that use more system resources than other SQL statements, or that use system resources more frequently than other SQL statements.

Use the Top SQL page to identify poorly performing SQL.

To view the Top SQL page:

1. On the Workspace home page, click the Utilities icon and then Database Monitor.

2. Click Top SQL.

3. 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 Search label.

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

   
   Description of the illustration view_icon.gif
   
   

   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.