Usage and Examples of SQL CREATE INDEX Keyword

SQL Keyword Reference

CREATE INDEX (Create Index)

The CREATE INDEX command is used to create indexes in tables (allowing duplicate values).

Indexes are used to retrieve data from databases very quickly. Users do not see indexes; they are only used to accelerate searches./Query.

The following SQL creates an index named 'idx_lastname' on the 'LastName' column of the 'Persons' table:

CREATE INDEX idx_lastname
ON Persons (LastName);

If you want to create an index on a column combination, you can list the column names within parentheses, separated by commas:

CREATE INDEX idx_pname
ON Persons (LastName, FirstName);

Note:The syntax for creating indexes varies between different databases. Therefore: Check the syntax used to create indexes in the database.

SQL Keyword Reference