>Hi!
>
>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao