Why does the sql query execute faster if I use the actual column names in the SELECT statement instead of SELECT *?
Advertisement
Answer
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.