Data Warehousing Community Forum
February 09, 2012, 01:14:20 pm

Pages: [1]   Go Down
  Print  
Author Topic: BITMAP Index in Datawarehouse  (Read 2158 times)
rasmi
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 2


View Profile
« on: September 17, 2007, 04:31:33 pm »

Why we are using BITMAP Index in Datawarehousing? What are the advantages?
Logged
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: September 17, 2007, 04:39:16 pm »

Bitmap index provides the same functionality as a regular index even though it uses a different representation internally. If the number of different key values is small, then bitmap indexes are very space efficient.

Bitmap indexes are good for low cardinality columns have a small number of distinct values
e.g. Gender or Marital Status

Bitmap indexes can dramatically improve the performance of ad hoc queries.

These indexes are primarily intended for decision support in data warehousing applications where users typically query the data rather than update it.

Therefore, bitmap indexing is of great benefit to data warehousing applications.

Update - For some more information on Bitmap index, Refer here

Hope that helps --  Smiley
« Last Edit: September 17, 2007, 04:46:21 pm by Sipra » Logged

Pages: [1]   Go Up
  Print  
 
Jump to: