Did you accidently change the where clause? If you were seeking on UPPER(partno) in your tests, and now you are seeking on just PARTNO then it won't use that index tag.
>>Are we talking a different network server? Could you be seeing a difference in network response time? Did you add any indices to the .cdx on your personal copy?
>>
>
>Thanks for your reply. No on both accounts, it's all on one NT server...there is an addition though...I was checking it out, and while everything is still slower, I noticed that a SELECT on a description doesn't take near as long as a SELECT on a part number...it turns out that there are 2 indexes in the main database for the part number, one is descending, based on part number alone, the other is ascending based on UPPER(partno). Could that compound the difference? Is there a way I can make sure that my SELECT statement will use the ascending index? Is this a valid concern? ...the quest continues;)
--Todd Sherman
-Wake Up! Smell the Coffee!