SQL Optimizer for SAP ASE 3.9 - Release Notes

New Analysis Wizard: Select SQL Page

View New Analysis Wizard: Select SQL Page

The Select SQL page is used to select the SQL statements whose query plans you want to analyze to see which Indexes are used and which are not used by these SQL statements.

Select SQL to check for unused indexes:

Select SQL from

The SQL statements used in an analysis can be taken from the SQL Repository or the SQL Scanner. If you select SQL statements from the SQL Scanner, these statements are added to the SQL Repository.

Bottom Pane

Select the SQL statements for the analysis.

Related Topic

Create an Index Usage Analysis