Hi!

>Do you have indexes on the Product field and DELETED()?
Yes, on the Product field. What do you mean with indexing on DELETED - I never create such an index?


>Is this query being run across the network?
>If the VFP data is sitting on a file server and
>you are running the query from a workstation, what kind
>of results do you get if you run the query at the file server?

Actually, I don't have a particular configuration on my mind - of course there is a better performance if it runs on a server or on a single user machine, but it's still not acceptable, because users need this information lots of times during entering, searching, etc.

Zlatko.