#sql is nice, high level language they said. Focus on the meaning of the query ...

Words
33
Reading
1 min
Listen
Play
2y

... and let the optimiser choose the right plan they said.
And then you extract part of the big query as a VIEW and suddenly the performance it 4x worse.