Wow. Add me to the list of admirers. Your website is really amazing. How do you find time (on top of the online support you generously give)? Are there more than one of you? Thank you! :o)



>How many records this query returns? You can find explanation why it's much faster when run intio cursor at http://www.berezniker.com/display/VFP/Queries+and+Filtered+Cursors
>
>>
>>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.