Is there a difference in performance between TOP and SET ROWCOUNT or do they just get executed in the same manner?
views:
637answers:
2
A:
google is your friend: http://www.devx.com/getHelpOn/10MinuteSolution/20564 http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=80&threadid=46112&enterthread=y
Andreas Niedermair
2009-01-22 11:33:38
+2
A:
Yes, functionally they are the same thing. As far as I know there are no significant performance differences between the two.
Just one thing to note is that once you have set rowcount this will persist for the life of the connection so make sure you reset it to 0 once you are done with it.
Andrew Hare
2009-01-22 11:36:03
http://stackoverflow.com/questions/863714/sql-rowcount-vs-top - has few other differences listed between these two, incase anyone is interested.
VoodooChild
2010-06-17 16:05:11