Chatta subito con l'assistenza
Chat con il supporto

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

New Analysis Wizard: Analyzer Page

Index Usage Analyzer > Create an Index Usage Analysis > New Analysis Wizard: Analyzer Page

The Analyzer page is used to name the analysis and to select the folder where the Analyzer information will be stored.

Item Description

Name

Enter the name for the analysis.

Description

Enter the description for the analysis.

Last modified

Displays the last modified date and time.

Save location

Displays the folder in the tree where the analysis is saved. In the bottom pane, select the folder where you want to save the analysis.

To create a new folder

  • Click Add Folder image\B_AddFolder.gif.

 

Related Topic

New Analysis Wizard: Select SQL Page

Index Usage Analyzer > Create an Index Usage Analysis > 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

Update an Index Usage Analysis

Index Usage Analyzer > Create an Index Usage Analysis > Update an Index Usage Analysis

You can update an analysis for unused indexes by rerunning the analysis with the same SQL statements from the original analysis or you can add or delete SQL statements from the analysis.

To update an analysis

  1. Right-click the analysis name in the left pane of the Index Usage Analysis window and select Update Analysis. The Update Analysis window has two tabs to select the options for changing an analysis before it is updated. It is not necessary to make any changes on these tabs before rerunning the analysis.

    Analyzer tab

    Selected SQL tab

  1. On the Analyzer tab, you can change the name and description of the analysis.

  2. On the Selected SQL tab, you can add or delete SQL statements to the analysis.

  3. After making the selections from the two tabs, click OK.

  4. When the analysis is finished, the Index Usage Analysis Details window displays with information the retrieve of the query plan for each SQL statement.

 

Related Topic

View Index Usage Analysis Details

Index Usage Analyzer > View Index Usage Analysis Details

The Index Usage Analysis Details window displays information about the retrieve of the query plan for each SQL statement.

The Index Usage Analysis Details window displays after the batch run process is completed unless the Show details on next batch run checkbox in the Index Usage Analysis Details window is unchecked.

To review the Index Usage Analysis Details window after an analysis

  1. Select View | Show Index Usage Analysis Details when the Index Usage Analysis window is active.

  2. Review this information to see if an error occurred during the retrieval of the query plan. Errors may occur if the selected SQL statements are from one database and user and you have set another database and user in the drop-down boxes at the bottom left of the main window.

 

Related Topic

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione