Lesson 2 of 11
Indexes
Read a query plan, pick a composite index column order, and know what an index costs on every write.
In this lesson
- What an index does
- How a B-tree finds a row
- Try four indexes
- At 50 million rows
- What an index costs
- Reading a query plan
- Index shapes
- Other index types
- What stays true
- Common mistakes
- Related topics and practice
Ultra Premium
Unlock this lesson
Ultra Premium opens the 11 premium lessons in Data, along with the rest of WhiteBox's premium lessons and problems.
Not ready yet? Read the free lesson: Backpressure