What Type Of Indexing Mechanism Do We Need To Use For A Typical Dataw

1.	What Type Of Indexing Mechanism Do We Need To Use For A Typical Datawarehouse?
Answer» 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. 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.

What Type Of Indexing Mechanism Do We Need To Use For A Typical Datawarehouse?

Answer»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?