An Adequate Design for Large Data Warehouse Systems: Bitmap Index Versus B-Tree Index

Provided by: NORTH ATLANTIC UNIVERSITY UNION
Topic: Data Management
Format: PDF
Although creating indexes on database is usually regarded as a common issue, it plays a key role in the query performance, particularly in the case of huge databases like a data warehouse where the queries are of complicated and ad hoc nature. Should an appropriate index structure be selected, the time required for query response will decrease extensively. To best of their knowledge, to date no comprehensive guideline has been provided for data warehouse analysts to opt for suitable indices.

Find By Topic