midSQL
What is an index in SQL?
Updated May 17, 2026
Short answer
An index speeds up data retrieval.
Deep explanation
Indexes improve query performance by reducing full table scans.
Real-world example
Fast lookup of users by email.
Common mistakes
- Over-indexing causing write slowdown.
Follow-up questions
- What are types of indexes?
- Do indexes always improve performance?