General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only