Which type of index is commonly used in data warehousing environments?
A) Join index
B) Bit-mapped index
C) Secondary index
D) Both A and B

Question

Quizplus · Accepted Answer

Join indexes and bit-mapped indexes are both commonly used in data warehousing environments to improve query performance. Join indexes allow for efficient execution of join operations on large tables, while bit-mapped indexes enable fast retrieval of data based on specific column values. Therefore, the best choice would be D, as it includes both join indexes and bit-mapped indexes.

Which Type of Index Is Commonly Used in Data Warehousing