The CREATE INDEX statement is bassically 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 sysntax is .....but its have not alowed duplicacy :
Syntax : CREATE UNIQUE INDEX index_name
ON table_name (column_name)
