5.1.3 Indexes & performance
Every entry filed under Indexes & performance and its subtopics.
Level
- Beginner 1
- Intermediate 0
- Advanced 1
What kind of help
- Guided project 0
- Explains an idea 2
- Step by step 0
- Cheat sheet 0
- Fixes an error 0
What do these mean?
- Beginner
- You are new to this topic.
- Intermediate
- You use it, and want to get better.
- Advanced
- You know it well and need the details.
- Guided project
- Build something small from start to finish, step by step.
- Explains an idea
- Plain words on how something works and why.
- Step by step
- Numbered steps to get one task done.
- Cheat sheet
- Commands and options in a table, to look up fast.
- Fixes an error
- An error message, what it means, and how to solve it.
2 entries match these filters
- 0294 What is an index (database)? A database index is a lookup structure that lets the database find rows fast instead of reading the whole table. Beginner · Explains an idea · Any system Article Indexes & performance 15 Oct 2026
- 0070 Indexes and EXPLAIN: making SQL queries fast An index is a sorted lookup structure that lets the database jump to matching rows instead of reading the whole table. EXPLAIN… Advanced · Explains an idea · Any system Article Indexes & performance 15 Oct 2026