SQL CREATE INDEX Statement

The CREATE INDEX statement is used to create indexes in tables.

Indexes allow the database application to find data fast; without reading the whole table.

SQL CREATE INDEX Syntax
Syntax :
            CREATE INDEX index_name  ON table_name (column_name)
Ex :
            CREATE INDEX IdStudent ON Student (LastName)

SQL CREATE UNIQUE INDEX Syntax

Syntax :

            CREATE UNIQUE INDEX index_name ON table_name (column_name)

Ex :

            CREATE INDEX IdStudent ON Student (LastName, FirstName)

TAG: SQL statement, database, table, student