INDEX ON LogicalField TAG LogicalField
should work just fine (and preferable for Rushmore to kick in given that you don't have expression like
IIF (LogicalField, '1', '0')
in your SELECT-SQL)
HTH
>I was just getting ready to add an index on a logical field and it occured to me that I always use iif(logicalfield,'1','0') in the index. Is this still the only way or is there something new?