Oracle Articles Blog

An Index is a DB object, which is used to improve the performance of  the data retrieval.

CREATE INDEX <INDEX NAME> ON <TABLE name>.(<COLUMN name>)

Types of Indexes:

Bitmap Index (Used for Low cardinality column)
Btree Index  (Used for high cardinality column)