LucidDbCreateIndex

Syntax

CREATE INDEX qualified-index-name
ON qualified-table-name
( unqualified-column-name, ... )

Note that the referenced table must be a local table, not a foreign table.

Example

CREATE INDEX cust_last_name
ON customer(last_name);

NOTE: As of 0.9.1 and noted in LucidDbConcurrencyControl, creating an index on a table with existing data keeps the catalog exclusive-locked for the duration of the execution instead of just for the metadata part. During the creation of the index logins will hang as the new connection attempts to look up the user in the catalog; other catalog access such as query preparation will also be blocked.