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