bitmap index as preferred choice in data warehousing environment

  • 2
  • 152
PeerSpot user

1 Answer

Real User
Jun 2, 2020
Real User
Jul 21, 2020

Thanks Gauri, Can you please elaborate below 2 points with example to avoid any possible ambiguity and gain crystal clarity:

1. Rowid bit map value of indexed values are stored together, making faster access for group data access
3. Bit mapping where 2 or more bitmap indexes can be intersected for faster access.
Regarding point 2, I guess space saving comes due to compression, however compression may be CPU intensive process.


PeerSpot user
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse. Updated: July 2024.
791,948 professionals have used our research since 2012.
Search for a product comparison in Cloud Data Warehouse
Cloud Data Warehouse
What is a Cloud Data Warehouse? A cloud data warehouse (often abbreviated as DW or DWH) is a repository that consolidates data from various sources (including internet of things devices, relationship databases, and other data systems) and stores it in a public cloud. It is built for high-performance analytics, scale, and ease of use. Because a data warehouse is dedicated to storing and analyzing data in order to reveal patterns, trends, and correlations it enables businesses to launch...
Download Cloud Data Warehouse ReportRead more

Related articles

Cloud Data Warehouse experts

Srini-Dhanaraj - PeerSpot reviewer
Joaquin Marques - PeerSpot reviewer
Miodrag Milojevic - PeerSpot reviewer
Atif Tariq - PeerSpot reviewer
Kevin McAllister - PeerSpot reviewer
Rohit Sircar - PeerSpot reviewer
SaurabhSingh4 - PeerSpot reviewer
Syed Zakaulla - PeerSpot reviewer