You have to try it out, it's never possible to calculate how fast a query will run. However, with the right indexes, your query should be almost instant.

And, to make it clear, if these index tags exist, you don't have to do anything, everything is done "automagically" by VFP. Run my code to create the indexes, and leave the rest to VFP.

>True, I have never used indexes to speed up queries. Now I have a better understanding,I was wondering if I could calculate the speed of a query given these indexes. Giving this query in my message how fast should it run with these indexes?
>
>>It looks to me that you don't understand the concept of structural indexes. If >you create an index using the TAG keyword, the index is created in a CDX file with the same name as the DBF. The CDX will automatically be "connected" and updated whenever you use the DBF. This means that once the index tag is used, you can more or less forget about it, everything is handled automatically. Open help on the Index command, for more info.
>>
>>In this case, you do this ONCE, but observe that you must do it when nobody else uses the tables:

>>Use fondsen exclusive
>>Index on fonds_cd tag fonds_cd
>>Use koers_hist_tot exclusive
>>Index on fonds_cd tag fonds_cd
>>Index on dat_krs tag dat_krs
>>Use