Indexing mechanism used on fact table in typical datawarehouse is

- non – clustered indexes
- clustered indexes
- bitmap indexes
- Unique - Indexes

CORRECT ANSWER : bitmap indexes

Discussion Board
Bitmap Indexes

Bitmap indexes are widely used in data warehousing environments. The environments typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions. Bitmap indexes are most effective for queries that contain multiple conditions in the WHERE clause. They are not suitable for OLTP applications with large numbers of concurrent transactions modifying the data.

Prajakta Pandit 03-16-2017 05:53 AM

Write your comments


Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)