SQL Index

CREATE INDEX statement is used to create indexes in tables.
Indexes allow the database application to find data fast; without reading the whole table.

---

SYNTAX :

CREATE INDEX index_name
ON table_name (column_name);

Must Read:

Updating a table with indexes takes more time than updating a table without (because the indexes also need an update).
So you should only create indexes on columns (and tables) that will be frequently searched.

---

SQL CREATE UNIQUE INDEX Syntax:

Creates a unique index on a table. Duplicate values are not allowed:

CREATE UNIQUE INDEX index_name
ON table_name (column_name);