Why SELECT * is bad for SQL performance (2020)
> assuming that your application doesn’t actually need all the columns.<p>Title is a bit click-bait-ish; I was expecting some deep insight of why this:<p><pre><code>     SELECT A,B,C FROM TBL;
</code></pre>
was superior to this:<p><pre><code>     SELECT * FROM TBL;
</code></pre>
when the table had three columns. Instead we get a <i>wildcards are bad</i> argument; especially when that wildcard fetches data that you don't need etc; which I guess everyone agrees with.