Schedule - Nordic PGDay 2015
Fixing Nightmare Queries
Date: 2015-03-11
Time: 13:30–14:20
Room: Falconer 202-203
Every "optimizing query" tutorial shows lots of examples of how very small queries can be repaired. But real-life bad queries are often much, much more complex. How do you even begin with a query that contains five CTEs (one with a recursive CTE inside of it), a join against a set-returning function, and a custom operator?
We'll talk about approaches you can take to restructure, tweak and refactor these monstrous queries to get better (if not great) results out of them.