3 ms·
Why was the author not just doing returning * No need for the CTE to select everything…
by wordofx 1y ago
Why was the author not just doing returning *
No need for the CTE to select everything…
- tomnipotent 1y agoCould be a generational thing. There was a time not every query planner would properly eliminate columns based on the final projection and any intermediary copies required more I/O if you included everything. Even now I still find myself following "best practices" for things that haven't been relevant in a decade.