|< < 59 > >|

Transforming Relational Algebra Expressions

Transformations involving multiple kinds of operators

Project can be pushed below a join

Suppose we have tables R and S:
R(a, b, c) S(c, d, e)

Similar to pushing select below join.

Project can be pushed below join, as long as the join columns are not removed.

|< < 59 > >|