SQL by Classification
In Find SQL, SQL Optimizer groups the collected SQL into SQL Classification categories. The SQL by Classification page allows you to view the list of SQL for each classification category. You can also use this page to view the details of each statement.
To view SQL by Classification
- On the Search Results page for a current or previously-saved Find SQL session, scroll down to the SQL Classification panel.
- Click a color-coded classification category in the pie chart or the legend.
- The SQL by Classification page opens displaying the list of SQL in that category.
- Select a SQL statement to view SQL details.
- View the selected SQL statement's execution plan in the Execution Plan tab.
- Click
to view the batch or object script. The selected SQL is shown highlighted within the script.
- Click
to show only the SQL text again.
- Click View Batch or View Database Object to view batch/object statistics, as well as the other SQL statements in the batch/object.
- Use the Classification Type column to see how many SQL statements of each type are in the batch or object.
- Select the SQL Information tab to view the SQL classification rule used to classify the SQL.
-
The top-right corner of the window displays the classification category (Simple, Complex, Problematic, or Invalid).
- To view a different category, click the link and select a different SQL classification type from the drop-down list. For descriptions of classification categories, see SQL Classification Categories.
-
Click Switch to filter by classification rules in the same drop-down list to filter SQL by rules you select. This method displays SQL in all applicable categories according to the rules selected.
Note: Any rules that were not be used by SQL Optimizer to classify collected SQL in this Find SQL session are disabled in the drop-down list.
- Click
to return to the dashboard page.
Tip: You can enable/disable classification rules or define new rules in Options | General | SQL Classification. See SQL Classification Options for more information.
SQL Details Page
Review the following for additional information:
| Pane | Description | ||||
|---|---|---|---|---|---|
|
SQL Text |
Displays the SQL text of the selected SQL. Send to Optimize SQL by SQL Rewrite—Click to send the selected SQL to SQL Rewrite.
View Batch / View Database Object—Click to view details of the batch containing the SQL. Right-click SQL text to view additional options. | ||||
|
Execution Plan |
Execution Plan tab—See About Execution Plans (Find SQL) for more information. SQL Statistics tab—View statistics minimum and maximum values. SQL Information tab—Displays classification and classification rules details. | ||||
|
Top SQL |
Lists the Top n SQL. Select a SQL to view SQL text and statistics. View Statistics—Click the link to change the way the statistics are presented. |
Click View Summary Chart to return to the Results page.
Batch Details Page
Review the following for additional information:
| Pane | Description |
|---|---|
|
Batch Text |
Displays text of the selected batch. Right-click SQL text to view additional options. |
|
Batch Statistics |
At View Statistics, select one of the following:
|
|
Top Batches |
At View Statistics, select one of the following:
Expand the batch node to view the SQL in the batch. Select SQL to view SQL text and statistics. The SQL is shown highlighted in the batch text. |
Database Object Details Page
Review the following for additional information:
| Pane | Description |
|---|---|
|
Database Object Text |
Displays text of the selected object. Right-click SQL text to view additional options. |
|
Object Statistics |
View Statistics—Click link to select one of the following:
|
|
Top Database Objects |
View Statistics—Click link to select one of the following:
Expand the object node to view the SQL in the object. Select SQL to view SQL text and statistics. The SQL is shown highlighted in the object text. |
Click View Summary Chart to return to the Results page.