>Hope this helps you...
Thanks Stacy!
I knew about the set deleted thing, but I was pretty sure that wasn't the problem, as the tables and indexes were identical from one machine to the next.
The problem turned out to be the location of the temp files directory. It was on C:, and the app was running off of the D:, when I moved the temp files to D:, the new system out performed the old system by 3 to 1.
Thanks again for your suggestion, and the detailed explanation!
--Todd Sherman
-Wake Up! Smell the Coffee!