Lateral view decorrelation(VW_DCL) causes wrong results with rownum

(Sayan Malakshinov) Everyone knows that rownum in inline views blocks many query transformations, for example pushing/pulling predicates, scalar subquery unnesting, etc, and many people use it for such purposes as a workaround to avoid unwanted transformations(or even CBO bugs).

Register to Read