Which type of index should be used on a fact table?

Options
- A binary index
- A bitmap index
- A metadata index
- A database schema index

CORRECT ANSWER : A bitmap index

Discussion Board
Bitmap index

Bitmap indexes are used on a fact table. Bitmap indexes are widely used in data warehousing environments. It reduces response time for large classes of ad hoc queries and storage requirements compared to other indexing techniques. It provides efficient maintenance during parallel DML and loads.

Prajakta Pandit 02-8-2017 10:54 PM

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.)


Related Content

Advertisement
 
▲