1. A computer-implemented method, comprising: generating a transformed query based on a particular query, wherein said particular query includes: an outer query; a view within a FROM list of the outer query; a join predicate that references: a column of an outer table of the outer query, and a column returned by the view; wherein said view includes: a GROUP BY operator that references a certain column upon which the column returned by the view is based, or a DISTINCT operator that references a certain column upon which the column returned by view is based; and wherein generating the transformed query includes pushing down the join predicate to create a pushed down join predicate that references the column of the outer table and a certain column returned by the view is based.