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