- The query optimizer will
transform the
above
logical query plan as follows:
-
σyear=1979
can be pushed down
(commutative law):
-
σyear=1979
and
σstudioName='Paramount'
can be combined:
-
πtitle,year
can be
absorbed by
πtitle:
-
σyear=1979
can be pushed down
(commutative law):