摘要
多连接查询优化是提高数据库性能的关键问题之一.查询优化主要针对连接等一些具有较高执行代价的操作进行研究.在分布式查询优化中,应同时考虑本地处理代价和传输代价.提出了一种应用聚簇索引来优化多连接查询的方法,旨在减小查询的代价.分析对比证明该方法具有较好的效果.
An optimization method for multi-join queries is one of key factors to improve the performance of database systems. The query optimization mainly researches into some operations that have higher executing cost. In the distributed query optimization, both local processing cost and transmission cost should be thought over simultaneously. This paper puts forward a method for multi-join queries applying cluster index. The purpose is to reduce the cost of queries. It has been verified by the simulation study that this method has better result than n-PSJ.
出处
《大连理工大学学报》
EI
CAS
CSCD
北大核心
2003年第z1期186-189,共4页
Journal of Dalian University of Technology
关键词
查询优化
多连接
聚簇索引
query optimization
multi-join
cluster index