Hi Fabio,
The SYS(3054) function reports on WHERE (Filter) and JOIN conditions only. The MAX(exp)/MIN(exp) optimization doesn't belong to either. I agree, it would be nice if it has been reported also.
>On VFP9 MAX(exp),MIN(exp) can use a index when exp="fieldName",
>but the syntax have to be pure.
>The SYS(3054) return none or full ( a bug ) in any case
>Another issue:
>You cannot define a single index that optimize
>the ON/OFF SET("DELETED") setting.
<snip>
--sb--