Chat now with support
Chat with Support

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

Create Indexes

Index Advisor > Create Indexes

Once the index candidates have been reviewed, you can create an index on the database.

To create an index

  1. In the bottom right pane of the Index Advisor window, select the Index Set you want to create.

  2. Select Index | Create Index(es).

  3. The Create Indexes window displays with the CREATE INDEX statement for the selected Index Set. Click Create.


Related Topics

Analyze Impact of New Indexes

Index Advisor > Analyze Impact of New Indexes

Analyzing the impact of new indexes on other SQL statements before permanently creating them on your database is essential. While improving the performance of one SQL statement, new indexes may degrade the performance of others.

First, generate or create the Index candidates for your original SQL statement in the Index Advisor window and determined which Index Set(s) give you the most performance for your SQL statement. Before performing the Index Impact Analysis function, you must save the SQL statements that may be impacted by the creation of new indexes in the SQL Repository or SQL Scanner.

To analyze the impact of creating the new indexes

  1. In the Index Advisor window, select the bottom-left pane of the Index Set tab for the indexes that you want to analyze.

  2. Click image\B_ImpactAnalysis.gif.  


Related Topic

Clear All Index Alternatives

Index Advisor > Clear All Index Alternatives

You can clear all the Index Sets that have been generated in the Index Advisor window.

To clear all the Index Sets

Click image\B_ClearAllIndexSets.gif.


Related Topics

Index Advisor Functions

Index Advisor > Index Advisor Functions

Below is a list of available functions within the Index Advisor window.

Button or Menu


Index Menu

image\B_AdviseIndexes.gif image\b_AbortAdviseIndexes.gif

Advise Indexes / Abort Advise Indexes

Index Menu


User-Defined Index

Index Menu


Show Plan

Index Menu

Show Default Plan

Index Menu


Batch Show Plan

Index Menu


Run Result

Index Menu


Run for First Record

Index Menu


Run for All Records

Index Menu

image\B_BatchRun.gif image\B_AbortBatchRun.gif

Batch Run / Abort Batch Run

Index Menu

Create Indexes

Index Menu


Clear All Index Sets

Navigate Menu

image\B_FirstSQL.gif image\B_PreviousSet.gif image\B_NextSet.gif image\B_LastSQL.gif

First Set, Previous Set, Next Set, Last Set

Edit Menu


Send to SQL Optimizer

Edit Menu


Copy to SQL Worksheet

View Menu

Show Index Advising Details

View Menu

Show Batch Run Details


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating