>>You cannot use group by or create index on bit data type.
>
>Sergey,
>I agree it is a PITA with respect to not being to group by. You then have to go through the hassle of converting to something you can group on and specifying that in the GROUP BY clause.
>
>But when would you want to index on a bit field? That would be like indexing on DELETED(). < gd&r >

I don't really know, but it's nice to be able too :)

I'm curious, would SQL Server use index on "logical" tinyint field if say we are looking for records with value 1 in that field and they represent only 1% or less of total number of records?