Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
changing the number of input rows. Therefore, the window operator can be used for decorrelation. If interested, see Enhanced Subquery Optimizations in Oracle[4] and WinMagic: Subquery Elimination Using Window Aggregation[3]. For rewriting after decorrelation, window operators are directly used to