CREATE INDEX

CREATE INDEX constructs an index on the specified column(s) of a table.

Note

Indexes can significantly improve query performance.

Syntax

CREATE INDEX index_name ON table_name (column_name);

Parameter	Description
index_name	Name of the index to create
table_name	Name of the table