SQL Statements › CREATE INDEX › Processing

Processing

CREATE INDEX processing is done by:

1. Locking the table to be indexed,
2. Copying the rows to a temporary table while deleting them from the original table,
3. Adding the definition of the new index, and then
4. Adding the rows from the temporary table back to the original table.

Because of the amount of processing involved, adding an index through the CREATE INDEX statement may not be appropriate for tables with a large number of rows. You may wish to use DBUTLTY's BACKUP function to unload the table's area and then use DBUTLTY's LOAD function to null load the area before executing the CREATE INDEX statement. After adding the new key definition by executing the CREATE INDEX statement, DBUTLTY's LOAD function can be used to reload the area.

Note: For information on using DBUTLTY, see the CA Datacom/DB DBUTLTY Reference Guide.

The sum of the lengths of all columns to be included in the index must be no more than 180.