Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

Add Index Wizard

ClosedView Add Index Wizar

The Add Index wizard is used to create the DDL for creating of the indexes for the Index Impact Analysis. This wizard is available on the Index page in the Index Impact Analyzer's New Analysis wizard. 

To open this Add Index wizard

Click image\B_AddIndex.gif.

Item Description
Index name Enter a name for the index.

Database

Select the database where the index is to be created from the drop-down list.

Owner

Select the owner of the index from the drop-down list.

Table

Select the table where the index is to be created from the drop-down list.

Table columns

List of all the columns from the selected table.

Index columns

Move the columns to be indexed from the Table columns list by either double-clicking the column or highlighting the column and clicking image\B_AddDatabaseObjects.gif.

Unique

Specify to create a unique index.

Clustered/Nonclustered

Select to create either a clustered or a nonclustered index

 

Related Topic

Create an Index Impact Analyzer

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating