xxxxxxxxxx
1 Clustered index
2 Non clustered index,
3 BTREE(Balanced Tree) index,
4 Unique Index,
5 Composite Index,
6 Function based index
7 Bitmap index
xxxxxxxxxx
-- Creating an index on a table
CREATE INDEX index_name
ON table_name (column_name);