|
What type of Indexing mechanism do we need to use for a typical datawarehouse?
Data Warehousing Interview Questions and Answers
(Continued from previous question...)
What type of Indexing mechanism do we need to use for a typical datawarehouse?
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.
(Continued on next question...)
Other Interview Questions
| 