Home Forums Article Discussions Article Discussions by Author Discuss content posted by David Durant Stairway to SQL Server Indexes: Step 7, Filtered Indexes RE: Stairway to SQL Server Indexes: Step 7, Filtered Indexes
roger.plowman
SSChampion
Points: 10265
More actions
August 24, 2011 at 6:41 am
#1372507
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?