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