>>Here's the statement:
>>
>>SELECT Base_Payment.PIN, ;
>> Base_Payment.Payment_Key ;
>> FROM Base_Payment ;
>> WHERE Base_Payment.Payment_Key = 10348 ;
>> INTO CURSOR ;
>> C_SomeCursor
>>
>>466 Celeron, 128 Ram, Win98, VFP 6.0 SP3
>>
>>There are 5 indexes, 3 on dates, one for PIN (Primary) and
>>one for the Payment_Key. PIN and Payment_Key are integers.
>>The above statement will return 36 records, but it takes
>>a WHOPPING 141 seconds to do so. I know this isn't right
>>or at least I wouldn't think so. OPTIMIZE is ON and I've
>>deleted and recreated the indexes.
>>
>>What's wrong with this picture?
>>
>>Thanks,
>>Steve
>
>And I forgot to add; the base_payment table is 300 mb.

Network issue?