Types of Indexes

Types of Indexes in Oracle

• B-tree Index: Default index type, suitable for most queries.
• Bitmap Index: Efficient for columns with low cardinality (few distinct values).
• Unique Index: Ensures all values in indexed column(s) are unique.

CREATE UNIQUE INDEX emp_email_idx ON employees(email);