Re:Why SELECT * is bad for SQL performance (2020)
by dutchmartin on Monday February 15, 2021 @06:08AM
(#26141561)
Can’t we just argue that using the * wildcard is just a great feature when you are writing sql queries on test data. I personally use it a lot when writing joins to eventually get the data I want or to execute a aggregating function like count().
But I think it is interesting to know if writing down all your table column names also delivers faster queries in other DBMS systems.
[ Parent
| on HN ]