Hello I am trying to denormalize multiple tables and create an index to increase the performance of a search function that we have. The problem when I denormalize is that its hard to find what columns to index and what to not. Alot of the columns that I am quering against are not selective enough, but if I dont put an index on them then it will a burden since the bookmark lookup will be heavy. I am then thinking of creating an index over the selective columns, and then also add a bitmask column. The bitmask column should include all my non selective columns. Let me give you an example of how I am thinking. This could be a couple of non selective columns. Gender, LanguageId, HasPicture if I then create a bitmask and say Male = 1, Female = 2, England = 4, France = 8, HasPicture = 16, HasNoPicture = 32 Then if I want to query for every male in france that has a picture (1+8+16) which gives me 25. Which most probably will be selective enough and also simple for sql-server to search and sort. I know that this kind of database design is disgusting, so if you might have other ideas please step forward and give me suggestions! Otherwise you could just comment the idea, or point to an article describing this method? I am sure that this must have been discussed before?