CREATE INDEX

 

Function

This command will create an index over the specified columns, on the specified table.

 

Syntax

create_index.bmp

 

Note: CREATE INDEX is not supported by CONNX for VSAM/CICS.

For the Adabas SQL Gateway, the ASC and DESC keywords are not supported.

 

Example:

CREATE INDEX test_index on test(Companyname DESC, companyid ASC)