2 ms·
So could an optimizer be built that let's you have your cake and eat it too? CTE syntax but without the performance compromise?
by rkagerer 4y ago
So could an optimizer be built that let's you have your cake and eat it too? CTE syntax but without the performance compromise?
- emodendroket 4y agoBased on other comments, this has been done for psql, or at least to some extent. So that's the other thing... pre-emptively writing code in a non-intuitive way for performance reasons often leads to practices sticking around long past the rationale for them even being true.