Louis Davidson follows up from a prior post:
For example, it is often said that
SELECT *makes your queries slower. In a nuanced way, this is often true, but only if changes occur in the database where columns are added. So many readers (myself included) see something that is demonstrably not 100% being treated as such, and they tune out.There are plenty of other reasons you shouldn’t use that construct, no matter what.
In this post, I want to admit to having my mind changed, and I will go back and change the previous post.
One thing I really appreciate about Louis is his willingness to listen to new information, update his priors, and outright say “Hey, here’s what I thought before and now I believe this instead.” That’s a commendable trait.