• My database design requires the use of bit fields, the majority of which will be false, and it would be nice to have a filtered index for bit fields that are true.

    Does this work? Or will the optimizer skip over bit field indexes?