In theory, it should slow down the query, precisely because VFP uses the index. (Reasons in FAQ # 8109.) But in actual tests, it seems that it will sometimes speed things up, sometimes make it slower - and that is the reason, IMNSHO, that there is so much controversy over this issue. Better do some comparison tests for your specific circumstances.
>For years, I have used an index tag on expression DELETED(). I don't remember, but think, at one point I read somewhere that having tag on DELTED() helps speeding the queries. This might have been when I was still using Clipper (before I moved to VFP), I don't remember.
>
>My question is, does it really help?
>
>Thank you.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
