Progress
SQL-89
Guide and Reference
Indexes
Indexes provide for more efficient retrieval of rows and optimize the performance of queries. In addition to using the UNIQUE option in a CREATE TABLE statement to create indexes, you can add and delete index definitions directly. You can use the following SQL statements to add and drop indexes.
CREATE INDEX
Creates an index on one or more columns.
DROP INDEX
Deletes an index.
Only the owner of a table can add and delete indexes on that table.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |