Skip to main content
PProfileMatch
Read Play

Play mode - ride path

Database Indexing

Understand B-trees, composite indexes and query plans, and know when an index helps or hurts

0 of 4 lessons passed0%

0 / 12 stars

0 / 20 tricks - Trick Book
  1. 1

    Database Indexing: How a B-Tree Index Speeds Up Lookups

    5-stop ride7 min read

    ReadQuiz onlyStart
  2. 2

    Composite and Covering Indexes: Column Order in Database Indexing

    5-stop ride5 min read

    ReadQuiz onlyRide
  3. 3

    Reading Query Plans in Database Indexing: EXPLAIN in Practice

    5-stop ride6 min read

    ReadQuiz onlyRide
  4. 4

    Database Indexing Costs: Write Overhead, Bloat and When Not to Index

    5-stop ride6 min read

    ReadQuiz onlyRide

Each ride has 5 stops: read the trick, answer the question, ride on. Pass with 3 of 5 correct (1 star), 4 for 2 stars, all 5 for 3 stars. Progress is saved in this browser. Prefer to read first? Open the reading version of Database Indexing.