What type of Indexing mechanism do we need to us
More DBA job interview questions and answers at
(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.
(Continued on next question...)
Other Job Interview Questions