Progress
Embedded SQL-92
Guide and Reference
CREATE INDEX
The CREATE INDEX statement creates an index on one or more columns of a table. The purpose of an index is to improve the retrieval time for rows in a table. You can specify an index in ascending order (ASC) or descending order (DESC).
EXAMPLEThe index in this CREATE INDEX example is specified on the single column cust_no, and is of ascending order on the value of the column:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |