SQL Server查询优化技术

Query Optimization Technique in SQL Server

给出了在SQL Server中优化查询性能的方法,指出通过选取索引字段、设计高性能的应用程序、使用存储过程代替游标及分散存储数据的方法可优化查询性能。

Methods of optimizing query performance in SQL Server are given. The query performance would be optimized by selecting index field, designing high performance application, replacing cursor with stored process and decentralizing stored data.