Indexes and How They Improve Performance

What is an Index?

An index is a database object that improves the speed of data retrieval operations.

Analogy:

Like an index in a book – you don’t flip every page to find a topic.

Types of Indexes:

• B-Tree (default)
• Bitmap
• Function-based

Example:

CREATE INDEX emp_name_idx ON employees(last_name);