| 应用聚簇索引的多连接查询优化方法 |
| |
| 引用本文： | 孟军,李建强,张大鲲.应用聚簇索引的多连接查询优化方法[J].大连理工大学学报,2003,43(Z1):186-189. |
| |
| 作者姓名： | 孟军 李建强 张大鲲 |
| |
| 作者单位： | 大连理工大学计算机科学与工程系,辽宁,大连,116024 |
| |
| 摘 要： | 多连接查询优化是提高数据库性能的关键问题之一.查询优化主要针对连接等一些具有较高执行代价的操作进行研究.在分布式查询优化中,应同时考虑本地处理代价和传输代价.提出了一种应用聚簇索引来优化多连接查询的方法,旨在减小查询的代价.分析对比证明该方法具有较好的效果.
|
| 关 键 词： | 查询优化 多连接 聚簇索引 |
| 文章编号： | 1000-8608(2003)S1-S186-04 |
| 修稿时间： | 2003年6月5日 |
An optimization method for multi-join queries applying cluster index |
| |
| Abstract: | 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. |
| |
| Keywords: | query optimization multi-join cluster index |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
