Types of Indexes

Published on: July 26, 2025 | Published by: Sai Sreeram Gundepudi

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);