se (join condition)
attributes. And as a back reference store the
tupleid of the original whole tuple in the "working"
tuple. At the final output stage perform a lookup to
retrieve the select clause attributes of only the
qualifying tuple. Thus enabling us to work with really
small sized da
limit then)
Another way of putting this would be, why don't we
push the projection operator as far down as possible.
In this case we also add the attributes in the
selection operator (of relational algebra) to the
projection. And then perform a join on the smaller
resulting relation.
Regards,
Documentation
section 2.3.1: Figure \ref{parsetree},
\ref{where_clause}
section 2.3.2 Figure \ref{transformed},
\ref{transformed_where}
2.5.2 \ref{plan} \ref{simple_select}.
}
Could you please point out where these figures are
available.
Regards
Anagh Lal
