News for hackers. Stuff that matters.

A comment on Literate SQL. Parent comment

Re:Literate SQL by gregmac on Sunday June 25, 2017 @04:29PM (#14631991)
Worse, someone is using the view (that joins several tables) in a join to get one extra field, which would be a simple single join -- they just didn't bother to check where it came from because 95% of the time that view gets used, and no one questions it. I've seen it happen more than once.
[ Parent | on HN ]
Re:Literate SQL by PeterisP on Sunday June 25, 2017 @07:15PM (#14632778)
Why would that be a problem?

Unless you're fetching all the unneeded fields as well, in any decent DBMS both approaches would result in the exact same execution plan with the exact same performance, the unneeded parts/joins of the view wouldn't be executed.

[ Parent | on HN ]