About Top SQL

Previous

Next

---

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 Database Home Page, click the Administration icon and then Monitor.

2. If prompted, enter the appropriate administrator username and password and click Login.

3. Click the Top SQL icon.

   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 item help

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

   
   Description of the illustration view_icon.gif
   
   

   The SQL Plan page appears.

   The SQL Plan page contains 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.