摘要
优化关系数据库的查询性能一直是信息系统开发人员关注的重要课题。以SQL Server为例,分析导致对多表连接及查询结果分组时处理低效的原因,阐述了在应用中如何合理地设计SQL语句,以获得较高性能的方法。
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.
出处
《计算机工程》
EI
CAS
CSCD
北大核心
2000年第7期185-187,共3页
Computer Engineering