>There is filtering in the
SELECT in question, but I was trying to establish if the
JOIN itself would be affected by the additional index.
>
>Kev
I understand that VFP uses available indices automatically (whether this speeds things up or not - sometimes it doesn't) for all aspects of query optimization.
Hilmar.
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)