International Journal of Engineering Associates
Data warehouse system is becoming more and more important for decision-makers. Most of the queries against a large data warehouse are complex and iterative. The ability to answer these queries efficiently is a critical issue in the data warehouse environment. If the right index structures are built on columns, the performance of queries, especially ad hoc queries will be greatly enhanced. The objective of this paper is to propose an indexing techniques being used in both academic research and industrial applications. In addition, the authors identify the factors that need to be considered when one wants to build a proper index on base data. Indexing is the key to achieve this objective without adding additional hardware.