< snipped >
>As far as I know compound indexes are optimizable as long as the left side of the expression exactly matches the index expression.
>
>e.g.
>LOCATE FOR Groupname + TRANSFORM(lgroup,"Y") = "SomeGroupName"
>
>should be optimized in the above example.

This is actually true and I was wrong when I said that compound indexes were not optimizable. The left side must match exactly.