>>Read articles on Rushmore optimization in help file.
>>
>>sys(3054) shows optimization level for filters in the WHERE contdition only. Join condition does use optimization, but never reported by sys(3054) function in VFP6.0 (in VFP7.0 it does reports).
>>
>
>Vlad,
>Are you sure about that? I've used sys(3054,11) to display JOIN optimzation levels and VFP 6 does report what indexes are being used.

SYS(3054,11) can display 'Full' optimization even when join conditions are not optimized. I just tested this. Create two tables with join fields that are not indexed. make a Select statement with such join fields and filter statement by some other field that is indexed. Don;t forget to add 'deleted()' tags or set deleted off. Aftere select both tables optimized as 'full'. But join condition is not optimized, I get though message 'Joining table aaa and table bbb using temp index', that means that VFP made index manually for joining (that, of course, takes time).

As you see, the things reported by sys(1054,11) function are quite not consistent.