Optimization of Analytic Window Functions

Yu Cao, Chee-Yong Chan, Jie Li +1

Analytic functions represent the state-of-the-art way of performing complex data analysis within a single SQL statement. In particular, an important class of analytic functions tha…