The Impact of Indexes on Data Warehouse Performance

Provided by: International Journal of Computer Science Issues
Topic: Data Management
Format: PDF
A data warehouse designer should consider the effectiveness of data query, this depends on the selection of relevant indexes and their combination with the materialized views, note that the index selection is a NP-complete problem, because the number of indexes is exponential in the total number of attributes in the database, So, it is necessary to provide, while the data warehouse design, the suitable type of index for this data warehouse. This paper presents, in some steps, a comparative study between the index B-tree and bitmap type, their advantages and disadvantages, with a real experiment based on two factors: size of index and clustering factor, this shows that the Bitmap index is more advantageous than the B-tree one.

Find By Topic