News for hackers. Stuff that matters.
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.
Re:Why SELECT * is bad for SQL performance (2020) by vinger on Monday February 15, 2021 @01:31PM (#26145568)
In theory yes. When you are joining two tables that have the same column names you have to alias them anyways.