Data 0/11

Lesson 2 of 11

Indexes

Read a query plan, pick a composite index column order, and know what an index costs on every write.

2,091 words · 10 min read Key topic Ultra Premium Useful background: Data modeling

In this lesson

  1. What an index does
  2. How a B-tree finds a row
  3. Try four indexes
  4. At 50 million rows
  5. What an index costs
  6. Reading a query plan
  7. Index shapes
  8. Other index types
  9. What stays true
  10. Common mistakes
  11. 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