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