>>I want to create an index on 2 fields, one is a character field and one is a logical field. I was thinking about this:
>>
>>INDEX ON Groupname + TRANSFORM(lgroup,"Y") tag Grouping
>>
>>Is there a better way to do this (or a reason I shouldn't)?
>
>Michael,
>
Compound indexes are not optimizable by Rushmore so you could be taking a performance risk by doing this.Are you sure? Before I check it in a Help...
> I would recommend just using the name and using a view to retrieve the data and order it by groupname and lgroup.
>
>Is there another reason to add the logical expression besides sorting?
If it's not broken, fix it until it is.
My Blog