| 基于多表连接的分组查询语句的性能分析与优化 |
| |
| 引用本文： | 王书海,刘明生,马银华,李金英. 基于多表连接的分组查询语句的性能分析与优化[J]. 计算机工程, 2000, 26(7): 185-187 |
| |
| 作者姓名： | 王书海 刘明生 马银华 李金英 |
| |
| 作者单位： | 石家庄铁道学院计算中心,石家庄 050043 |
| |
| 摘 要： | 优化关系数据库的查询性能一直是信息系统开发人员关注的重要课题，以ＳＱＬＳｅｒｖｅｒ为例，分析导致对多表连接及查询结果分组时处理低效的原因，阐述了在应用中如何合理地设计ＳＱＬ语句，以获得较高性能的方法。
|
| 关 键 词： | 关系数据库 分组查询 SQL语句 性能分析 优化 |
| 文章编号： | 1000-3428(2000)07-0185-03 |
| 修稿时间： | 1999-10-13 |
Analyzing and Optimizing the Performance of Querying by Group Based on Multi-join-table |
| |
| WANG Shuhai,LIU Mingsheng,MA Yinhua,LI Jinying. Analyzing and Optimizing the Performance of Querying by Group Based on Multi-join-table[J]. Computer Engineering, 2000, 26(7): 185-187 |
| |
| Authors: | WANG Shuhai LIU Mingsheng MA Yinhua LI Jinying |
| |
| Abstract: | Optimizing the performance of querying in related database, which is one of the important aspects of information system development. draws more attention in recent years. Taking SoL Server products for example, this paper analyzes the reasons for the low performance in joined-table queries by group and explains how to design query commands which can achieve high performance. |
| |
| Keywords: | Related database Connection Querying by group SQL |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
