1

I encounter an issue where when I use sp_executesql to select * (6 seconds) is much faster than select column fields (2min). (using sql server 2005)

I can't understand why the performance is so much different as I thought select by column field suppose to be faster. (or it shouldn't be so much different..)

anyone help?

Liam
  • 27,717
  • 28
  • 128
  • 190
Eddie
  • 11
  • 1
  • Are you sure that's the only difference? Can you get some query execution plans? Maybe a weird cached query plan from back when the table sizes have been much different? Can you restart the database server and try again? – Thilo Jan 15 '15 at 01:34
  • 3
    possible duplicate of [select \* vs select column](http://stackoverflow.com/questions/3180375/select-vs-select-column) – Nadeem_MK Jan 22 '15 at 06:03

0 Answers0