- 01How indexes find rows4 questions
- 02Lookups and covering indexes3 questions
- 03PostgreSQL
01
How indexes find rows
1.1 What happens when you search for a row without an index?
Easy
1 min
1.2 What is a clustered index?
Medium
1 min
1.3 Why does a B+ tree lookup on a large table read only a few pages?
Medium
1 min
1.4 What is stored in a nonclustered index?
Medium
1 min
02
Lookups and covering indexes
2.1 What is a Key Lookup?
Medium
1 min
2.2 What does INCLUDE do, and what makes an index covering?
Medium
1 min
2.3 Why not add an index for every query?
Easy
1 min
03
PostgreSQL
3.1 How does this differ in PostgreSQL?
Medium
1 min