CREATE INDEX

Home

4D v18

CREATE INDEX



	Command CREATE INDCREATE [UNIQUE] INDEX sql_name ON sql_name (column_reference, ... , column_reference)

Description

The CREATE INDEX command is used to create an index (sql_name) on one or more columns of an existing table (sql_name) designated by one or more column_reference type arguments. Indexes are transparent to users and serve to speed up queries.

Note: The UNIQUE attribute is not supported for indexes by the 4D SQL engine. It can be passed to CREATE INDEX for compatibility with generic SQL scripts (no error is generated), but it will be ignored. Use UNIQUE keyword in column_definition of CREATE TABLE to disallow duplicate values in a column.

Example

Here is a simple example for creating an index:

CREATE INDEX ID_INDEX ON ACTOR_FANS (ID)