Skip to content
Advertisement

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 *?

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.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement