>Hi
>
>Is it better to use JOINS on Indexed fields, or doesn't it make a difference?
>
>Thanks
>Kev
Kev,
It makes a difference. If you look at the output from sys(3054,11), you can see the opitmization level for VFP Joins too. If the indexes exist, VFP will use these for the join.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao