>How many records this query returns?
It returns 754,322 records, it is not really that I want to speed it up, but I just want to know how I can estimate the time given a query, so that I don't have waste time in "optimization" for it and have a good feeling about it.
>You can find explanation why it's much faster when run intio cursor at
http://www.berezniker.com/display/VFP/Queries+and+Filtered+Cursors>
Thanks, that would also explain why I would get other errors if I would query on a filtered cursor.
>>
>>I have the following query which takes 5 minutes. I'm wondering if this is normal?
>>
>>Select *;
>>from mutbdrg;
>>where year(dat_verw) = 2007 and year(dati_vrsch)=2007;
>>into table curMutatiePolis
>>
>>
>>I have an index on year(dat_verw) and an index on year(dati_vrsch). The table mutbdrg is 8.5 millions big. Strange thing is if I do the query in the command window w/o an output to a table it takes 2 seconds.