Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
1.4.2
-
None
Description
For Window Functions, if a ROWS frame is used, then optimizations are made such that the row falling out of the frame is subtracted (whatever that means for the particular function) and the row coming into the frame is added.
If RANGE frame is used, then the intermediate results from the previous row are ignored and the entire frame is iterated and recalculated.
RANGE is the default for most Window Functions.
This MCOL is to look for ways to optimize RANGE in a similar fashion as ROWS.