1. A method for processing a multiple table query, comprising: determining if any tables in the query require materialization; for each table in the query that requires materialization, deriving at least one join predicate on a join column; determining if any tables earlier in a join sequence for the query has same join predicates; and applying the at least one derived join predicates to an earlier table in the join sequence, if there is at least one table earlier in the join sequence that has the same join predicate.