db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Covering index

An index-only scan answers a query from the index alone and never visits the table. INCLUDE adds payload columns that are stored but not searchable.

task

Get an Index Only Scan for SELECT customer_id, placed_at FROM orders WHERE customer_id = 5 (create the index, then VACUUM orders).

hints