CREATE INDEX
Function
This command will create an index over the specified columns, on the specified table.
Syntax
CREATE [UNIQUE] INDEX index_name ON table_specification (column_name [ASC]|[DESC]] [,])
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)