Rewrites: Group By and Join
•Schema:
–Product
(pid, unitprice,…)
–Sales(tid,
date, store, pid, units)
•Trees:
Join
groupBy(pid)
Sum(units)
Scan(Sales)
Filter(date
in Q2,2000)
Products
Filter (in NW)
Join
groupBy(pid)
Sum(units)
Scan(Sales)
Filter(date in Q2,2000)
Products
Filter (in NW)
