4D v14

CREATE INDEX

Home

 
Home
4D v14
4D SQL Reference
SQL Commands
CREATE INDEX

CREATE INDEX  


 

 

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

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.

Example  

Here is a simple example for creating an index:

CREATE INDEX ID_INDEX ON ACTOR_FANS (ID)

 
PROPERTIES 

Product: 4D
Theme: SQL Commands

 
SEE ALSO 

column_reference
DROP INDEX

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)