Indexes and Performance

How indexes work inside, how to read a query plan, and why a query is slow.

  1. 01

    How a B-Tree Index Works

    • easy
  2. 02

    Composite Index Column Order

    • medium
    • Pro
  3. 03

    Read a Query Plan

    • medium
    • Pro
  4. 04

    Why Is My Index Ignored?

    • medium
    • Pro
  5. 05

    Covering Indexes

    • medium
    • Pro
  6. 06

    The Cost of Too Many Indexes

    • medium
    • Pro
  7. 07

    Diagnose a Slow Query

    • hard
    • Pro