>>>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
>>
>>The first questions that come to mind for me are:
>>
>>What is the size of the table, i.e. number/size of records?
>>
>>Is this running on a local machine or over a network, i.e. any network issues?
>>
>>Is SET DELE ON, are there deleted records, how many are deleted, and is one of the indexes on DELETED()?
>>
>>Have you run the query with SYS(3054,1) to see the optimization level?
>>
>>Bill
>
>Hi Bill,
>
>Yeah, I did finally get around to using SYS(3054) and it indicated that I was out of memory. That was the problem.
>
>Thanks,
>Steve

Do you mean RAM? What message did you get?