table.index

A table.index definition is used to explicitly create indexes and unique constraints on a table.

Andromeda by default builds indexes on all primary keys and foreign keys. A primary key is also a unique constraint. You can use the table.index definition to create additional indexes on frequently-referenced columns or column combinations.

!<

Properties

index index_id. The first line of a table.index definition begins with the keyword 'index', a space, and then an index name that is unique within this table, (index_id) followed by a colon.

idx_unique. If set to Y, the index will also become a unique constraint.