Creating an Index 

Use

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

Prerequisites

You need to have the necessary user authorizations and the NOT EXCLUSIVE user attribute.

For an explanation of user authorizations and user attributes, see the Database Users section of the Concepts of the Database System documentation and the Authorization section of the SQL Reference Manual.

Procedure

...

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

       2.      In the Index Name field, enter a name for the index.

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

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

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

       6.      Select the required options:

Unique	Ensures that the indexed columns are unique
Index Name Uppercase	Automatically converts table names and column headers into upper case.

       7.      Choose Table Definition ® Create Index.

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

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