[dutchmartin]

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.

[vinger]

In theory yes. When you are joining two tables that have the same column names you have to alias them anyways.