Saved locally in this browser. Sync isn't connected on this device yet, so home and office won't match. Press the Sync button and enter your sync passcode. It then merges this device's progress with the database and keeps the latest.

Database

Day 45 of 140 · Week 7: Graphs, ASP.NET Core and Rate Limiter · Core Depth

Query Plans and Optimization

Reading execution plans proves you can debug slow queries in production. Know seeks vs scans, key lookups and parameter sniffing.

0/4 tasks · ~2.5h

Tasks

Search & resources

Click to search on YouTube or Google.

  • how to read SQL Server execution plan
  • Postgres EXPLAIN ANALYZE explained
  • keyset pagination vs offset