task Indexes · hard

Cover the event export

Export event_at and amount for shopper 7 on January 4, 2025. Create a full index with exactly (shopper_id, event_at, amount) and make the final query use a covering indexed search.

what to return

Columns

event_atamount in this order

Rows

16 rows · in the order asked

Watch for

Use the half-open interval [2025-01-04 00:00:00, 2025-01-05 00:00:00). Order by event_at then amount, ascending.

Choose any index name. Keep the source data unchanged. This task checks covering access, not execution time.

Skill

Build an index that supplies the selected payload without a table lookup. Refresher: Partitioning & workload trade-offs →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

Sample rows from each table. Each column shows its type underneath; → marks a link to another table.