浅谈SQL Server数据库查询性能的优化

Discussion and Study of SQL Database's Query Optimization

随着数据库应用系统中数据量的急剧增大,对数据库系统性能的优化显得极为重要。本文讨论了影响基于SQL Server应用系统性能的几种因素,并对SQL Server的查询机制和查询优化作了深入的探讨。

With the rapid growth of the data in the database application , the performance optimization of the database system becomes more and more important. This article discusses the factors that affect the performance of SQL Server ,the technology of the query mechanism and the query optimization of SQL Server.