>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
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.