Index Trade-off
Multiple Choice Medium
Question
What is the trade-off when adding an index to a column?
Hint
The index must be maintained on every write.
Explanation
Indexes speed up reads (SELECT) but slow down writes (INSERT, UPDATE, DELETE) because the index must be updated too. They also consume extra storage. Index columns you query often, not every column.
Related Resources
Related Lessons
- Indexes
Learn about indexes.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.