Creating an Index 

Use

You can use SQL Studio to create new indexes for database tables.

Prerequisites

You have the necessary user authorizations and have user attribute NOT EXCLUSIVE*.

Procedure

...

In the Catalog Manager select the database table that you want to create an index, and choose Catalog Manager ® New ® Index.

Enter a name for the index.

In the In Index field, choose Yes for the columns that you want to index values for.

To sort the index values in ascending or descending order, select the option ASC or DESC in the Sort field.

To change the sequence of the table columns, select a table column and use the Ý ß, arrows to move it up or down.

Select the required options:

Unique	Ensures the uniqueness of the indexed columns
Index name upper case	Automatic conversion of table names and column headers into upper case.

Choose Table Definition ® Create Index.

To export the SQL statement for creating the index to the SQL dialog, choose Index Definition ® Export to SQL Dialog.

 

*For an explanation of user authorizations and user attributes, see the User Concept section of the documentation The SAP DB Database System and the Authorization section of the Reference Manual: SAP DB.

For information on the syntax of CREATE INDEX statements, see the CREATE INDEX Statement section of the Reference Manual: SAP DB.