tempdb must be configured correctly for fast sort:
http://www.sqlusa.com/bestpractices/configureharddisk/
The difference from 1 sec to 5 mins does not make sense. How many rows in the output?
As noted above, index support should be added.
Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
No comments:
Post a Comment