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

Nope, memory issue. SYS(3054) indicated out of memory.

Thanks,
Steve