What is an index in SQL

Question

When to use it?

Answer 1

INDEX - find data easily

UNIQUE INDEX - duplicate values are not allowed

Syntax for INDEX:

CREATE INDEX INDEX_NAME ON TABLE_NAME(COLUMN);

Syntax for UNIQUE INDEX

CREATE UNIQUE INDEX INDEX_NAME ON TABLE_NAME(COLUMN);