8 ms·
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 join
by dutchmartin 6y ago
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 6y agoIn theory yes. When you are joining two tables that have the same column names you have to alias them anyways.