Concept
Database indexes
Sorted structures, usually B+trees, that let a database find rows without scanning the whole table.
Part of DatabasesDatabase indexes
Then learnSQL query optimisation
What to learn after Database indexes
- SQL query optimisationMost query tuning comes down to whether a good index exists and is used.
Connections to other concepts
- Part of
- Databases
Practise Database indexes
- Intermediate SQL and MySQL Interview Questions4 questions on Database indexes
- SQL Interview Questions for Freshers1 question on Database indexes
- Advanced SQL and MySQL Interview Questions1 question on Database indexes