Index based approach for heuristic query optimization in data warehouses
Chen Nan-nan · Computer Engineering and Applications Journal · 2010
In large data warehouse query processing,multi-joining of fact tables is often involved.The traditional query optimization method reduces the size of middle-product as possible as it can when calculating multi-joining,but this method is unable to get the best optimal result since it is not considered massive data in data warehouse whose fact tables have indexes.To solve the above problem,this paper proposes an index based approach for heuristic query optimization.Theoretical analysis and experimental results show that the method for querying cost and executing time significantly reduces and the method is effective.