| Basically indexes are used to find data more quickly as compare to data without indexes. We can not see indexes but one thing is to create indexes on columns that will searched more frequently.
(1)We can create index where duplicates value are allowed. Below is the syntax for that
CREATE INDEX index_name on table_name (coloumn_name)
(2)creates unique index on table where where no duplicate values are allowed.Bello is the syntax for that
CREATE UNIQUE INDEX index_name ON table_name (column_name) | | |