>>John,
>>
>>Do the production machines have temp files aimed at their local drives?
>
>Hi Jim,
>
>Thanks for responding. I'm not exactly sure what you mean, but I have noticed that on the users machines there are huge tmp files being created when I run this query. For instance, the example query should only return 5 records ( a couple of kb's) and the tmp file is 50,000 kb. This is killing me!! I'm going bonkers, and my not so patient users are beating down my door. Can you explain in a little more detail what you mean about the temp files.
>
>Thanks again,
>
John,

I mean, are the production machines creating their temp files on their local drives or on the network drives? If they are creating their temp files on the network dirves then it could explain the difference in performance.