What type of Indexing mechanism do we need to us

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(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 Job Interview Questions

• What is the difference between OLAP and datawarehosue?
• What are conformed dimensions?
• What is a Star Schema?
• Is OLAP databases are called decision support system ??? true/false?
• What are modeling tools available in the Market?
• What are the different architecture of datawarehouse?
• What is real time data-warehousing?
• Name some of modeling tools available in the Market?
• What is a CUBE in datawarehousing concept?
• What is active data warehousing?
• More...