Faced this question a few days back in an interview for the position of Sr. TSQL Developer.
The interviewer asked "What are bit-mapped Indexes?". Clueless I replied that, I've never heard of this type in my past experience.
Googled up and found that these exists in ORACLE.
But again to confirm, is there any type of bit-mapped index/object/concept in MS SQL Server?
View Complete Post