General Datawarehousing Interview Question:

Explain What type of Indexing mechanism do we need to use for a typical datawarehouse?

Submitted by: Administrator

On the fact table it is best to use bitmap indexes. Dimension tables can use bitmap and/or the other types of clustered/non-clustered, unique/non-unique indexes.

To my knowledge, SQLServer does not support bitmap indexes. Only Oracle supports bitmaps.
Submitted by: Administrator