A Comparitive Study of Indexing Techniques in Data Warehouse
The need for strategic information is escalating day by day and that can be fulfilled efficiently with the help of data warehouse indexing techniques. For this, one needs to maintain the data warehouse structure well. Data-warehouse has a broader scale and is completely equipped with the decision making process strategies. Since data in the data warehouse is enormous, so most of the queries in such a data warehouse will be complex and time taking too. Therefore, to speed up the processing time of these queries, indexing is used. At present, there are a number of indexing techniques available in the market. But according to the cardinality, size, processing speed, flexibility, and ease to make etc. different indexing techniques are visualized.