sqlsql-tuning

SQL SELECT clause tuning


Why does the sql query execute faster if I use the actual column names in the SELECT statement instead of SELECT *?


Solution

  • Because depending on the query it has to work out if there are unique names, what they all are, etc. Where as, if you specificy it, its all done for it.