Window Function Optimization: Co-Evaluation and Other Techniques

Daniel Lindner, Felix Naumann, Alberto Lerner

Window functions are among the most expressive features of modern SQL. Surprisingly, relatively little has been written about their optimization. Some techniques exist, such as pus…