Hi John,

I've read the other replies.

You call it a "big table" but really 20,000 records is tiny. You should be getting sub-second response time in my opinion.

While what you have been told about using ALLTRIM() in an index is true, the additional overhead imposed in this case should really be negligible. As a small aside it would be SET ANSI that you would need to set OFF, not SET EXACT.

I also feel that even if you have an index on DELETED(), in this case it should not be that problematic. It wouldn't hurt to delete that TAG unless you know that, in the longer run, you will have deleted records numbering over 10% of the table. If you know that you have NO DELETED RECORDS in the table then running with SET DELETED OFF will negate any impact of a TAG on DELETED().

I think I would suspect the network or possibly the server. What does the query run like when all data is on a local drive?

Good luck

JimN


> 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