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