25. One or more non-transitory computer-readable storage media storing instructions which, when executed by one or more computing devices, cause: transforming a first query, comprising a first lateral view that includes a first predicate that references a database object that is joined with the first lateral view, to a second query that includes: a second view without the first predicate that references the database object, wherein the database object is joined with the second view, and a second predicate outside the second view, wherein the second predicate corresponds to the first predicate, wherein the second predicate references the second view, and wherein the second query is semantically equivalent to the first query; generating an execution plan for executing the second query instead of the first query; wherein the method is performed by one or more computing devices.
25. One or more non-transitory computer-readable storage media storing instructions which, when executed by one or more computing devices, cause: transforming a first query, comprising a first lateral view that includes a first predicate that references a database object that is joined with the first lateral view, to a second query that includes: a second view without the first predicate that references the database object, wherein the database object is joined with the second view, and a second predicate outside the second view, wherein the second predicate corresponds to the first predicate, wherein the second predicate references the second view, and wherein the second query is semantically equivalent to the first query; generating an execution plan for executing the second query instead of the first query; wherein the method is performed by one or more computing devices. 32. The one or more non-transitory computer-readable storage media of claim 25 , wherein the second query, if executed, would cause a temporary organization of data from the database object and the second view and utilization of the temporary organization of data for evaluation of multiple rows of the outer join.