SELECT TOP can be slower than SET ROWCOUNT
Posted by: SQL Server 2005 Distilled,
on 21 Oct 2005 |
View original | Bookmarked: 0 time(s)
Davide Mauri shows an example of scenarios where SELECT TOP can be slower than SET ROWCOUNT. I tried his example in SQL Server 2000 (SP 3a) and SQL Server 2005 (Sept CTP), and verified that SET ROWCOUNT returned results at least five times faster as compared to SELECT TOP.
weblogs.sqlteam.com/dmauri/archive/2005/10/21/8076.aspx
...