>>Hi Todd,
>>
>>VFP uses two optimizations: Filter Criteria and Join Criteria . There're no Filter Criteria (WHERE clause) in both tables that why no optimization for cr and fd tables reported. However there's optimization on Join Criteria which is reported. Anyway, as long as query is fast enough, ther's nothing to worry about. :)
>
>
>Thanks Sergey. I'll lift a beer to you when I get home tonight.


Sounds good to me. Enjoy. :-)