Multiple choice

Which of the following is widely used in data warehousing environment, which typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions?

  1. B-tree index

  2. Bitmap index

  3. View

  4. Clustered index

  5. B+-tree

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Bitmap indexes are widely used in data warehousing environment, which typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions.