Presented by:

Postgres jedi

Willem Booysen

whbooysen@gmail.com

Accountant turned Accidental DBA. Financial Manager and Accounting Partner during the day and SQL scripter during the night.

Download the Slides

Window Functions appear to be generally underutilised in the real world. Compared to CTE's and basic Select queries, one seldom sees Window Functions in SQL blogs, stackoverflow pages, forums, etc. (unless the article is dedicated to Window Functions). My opinion is that this is due to the syntax and different way of thinking about Window Functions compared to normal SQL syntax and use. This talk aims to change the way we think about Window Functions so that listeners can understand where to utilise them and hopefully how to speed up their own queries by opting to use Window Functions instead of Inner Joins or unecessary CTE's.

Code available at https://gist.github.com/IllusiveMilkman/70c319d60756b78dc11366ffdb5127b3

Date:
2018 October 9 11:20
Duration:
40 min
Room:
Baobab
Conference:
South Africa 2018
Language:
English
Track:
Development
Difficulty:
Medium