One option for improving query performance is to rewrite the query in order to obtain a completely different execution plan. In this episode we look at how it's possible to rewrite queries with Window Functions into more traditional GROUP BY syntax and what causes the difference in performance.
Subscribe and turn on notifications to never miss a weekly video: [ Ссылка ]
Related blog post with example code:
[ Ссылка ]
More examples with Window Functions: [ Ссылка ]
Download the StackOverflow database for yourself: [ Ссылка ]
Follow me on Twitter:
[ Ссылка ]
