4D v13.4CREATE INDEX |
||||||||||||||
|
4D v13.4
CREATE INDEX
CREATE INDEX
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. You can also pass the optional UNIQUE keyword to create an index that does not allow duplicate values. Here is a simple example for creating an index: CREATE INDEX ID_INDEX ON ACTOR_FANS (ID) |
PROPERTIES
Product: 4D INDEX SEE ALSO |
||||||||||||