In SQL 2008, a filtered index on one or another of the values in a bit column, can make a HUGE difference in performance.
In 2005 and earlier, just don't make it the leading edge of the index, and it should help, but not quite as much.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon