Optimization Method of Clustering Index in Data Warehouse
Wang Yi-gui · 2005
There are many computations about the aggregation function in the data warehouse, and the most time-consuming part is to execute the GROUP BY clause, which can be implemented by sorting in general. If the (clustering) index has been established about specified column in the GROUP BY clause, it is not necessary to sort the data, so the speed of computations about the aggregation function will be increased greatly. The clustering key will be established according to the flow of data access in order to do it. The paper gives an optimization method of (clustering) index.