关键词: 大容量数据仓库, 启发式方法, 索引, 查询代价

Abstract: 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.

Key words: large-capacity data warehouse, heuristic method, index, query cost