Learning on Web Dev Open is free for all.

System Design & Performance > Caching as architectureQuery Planner
Phase 06Caching as architecture310 of 434

Query Planner

Before you cache a query, be sure it needed caching. Rounds of plan reading and index choice against the clock.

Drill20 minAI off

Query Planner

Add the indexes that turn a collection scan into a bounded lookup.

Play Query Planner

You should now be able to

  • Read a plan and find the scan
  • Choose the index that removes it
Ask the community

Loading…

← PreviousCaching inside the applicationCaching as architectureNext →Scaling reads is the easy halfScale, consistency and failure