John,
A result set of 4 records out of 20,000 should be instantaneous if the query is fully optimized. Does your query contain several joins? I've noted that performance may drop dramatically when you join many tables. Could you show us your query?


>Hi,
> I am using SQL to query records from a big table. VFP need 4 secs to retrieve 4 records out of 20,000 records with FULL OPTIMIZED under 100 BASET Network. Is it acceptable? Any way to impove?
>
>Thank you