The CREATE INDEX statement is basically use for the create indexes in tables. Its mainly Indexes allow the database application to find data fast, without reading the whole table.
Syntax : CREATE INDEX index_name ON table_name (column_name)
When we would like to Unique Index then syntax,but its have not allowed duplicate :
Syntax : CREATE UNIQUE INDEX index_name ON table_name (column_name)