>>>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.


The users machines are creating the temp files on their local drives c:\windows\temp. What doesn't make any since to me (other than I don't know what the heck is going on here), is why the temp file is so big...It is acting like a badly constructed query, but I know this query works fine because it completes on my development machine in less than a second. Can you think of any other suggestions? Thanks.

John