摘要： 优化关系数据库的查询性能一直是信息系统开发人员关注的重要课题。以ＳＱＬ Ｓｅｒｖｅｒ为例，分析导致对多表连接及查询结果分组时处理低效的原因，阐述了在应用中如何合理地设计ＳＱＬ语句，以获得较高性能的方法。

关键词: 关系数据库, 连接, 分组查询, SQL

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.

中图分类号: 

• TP311