Make sense of database performance.
Move from query plans to index design, then understand why analytical workloads ask different questions.
01
Engineering guide · 3 min
02Read a PostgreSQL query plan without getting lost
Follow the work through a query plan, compare estimates with actual rows, and learn what to investigate before adding another index.
Tutorial · 3 min
03MySQL composite indexes: why column order matters
Build an index around a real access pattern, then use EXPLAIN to understand what it helps—and what it doesn't.
Comparison · 3 min
04OLTP and OLAP: two workloads, different priorities
Understand why checking out a shopping basket and analyzing a year of sales ask very different things of a database.
Tutorial · 3 min
BigQuery: scan less data before adding more compute
Use explicit columns and partition filters to reduce unnecessary work, then validate the bytes your query will process.