Well, you're trying to sort 1.6 million rows. To do that "quickly" (several seconds) requires a substantial amount of memory, depending on how big these rows are. If you do not have enough memory then is has to do a memory+disk sort which is substantially slower (minutes to hours).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]