• Have you compared the execution plans between the two environments to see if they are the same? How about any hits to the disk? How hard is your hardware working processing other queries in production?



    Shamless self promotion - read my blog http://sirsql.net