Transforming Relational Algebra Expressions
Transformations involving multiple kinds of operators
Select can be pushed below a join
Plan:
distinct(
project(
sort(
select(
join(
member u,
join(routing r, message m)),
u.name == 'Zyrianyhippy'),
[m.message_date]),
[m.message_date]))
Push the select on u.name below the join:
distinct(
project(
sort(
join(
select(member u, u.name == 'Zyrianyhippy'),
join(routing r, message m)),
[m.message_date]),
[m.message_date]))
|