tinyquery + tinydelta

Query

Ctrl+Enter Loading Python…

Time travel and planner

Loading versions…

Join reordering The cost model picks the join order. Off: join in the order written. Predicate pushdown Filters run below the joins. Off: one filter above them all.

Plan

Run a query to see its plan.

Result

Tables

orders tinydelta: id, customer_id, region, year; loading…
customers: id, name, tier; 200 rows, only 2 of them platinum
lineitem: order_id, sku, revenue; 4 items per order