You won't gain much indexing on a logical field because the values are very discrete.
>Is it a good idea to define a logical index in order to have an expression be optimized by rushmore or it isn't woth it?
>
>Could there be an expression be half optimized by rushmore or it's always an all or nothing situation?
>
>TIA
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer