Query Optimization Technique in SQL Server
Zhaoliang Liu · Journal of Jianghan Petroleum Institute · 2003
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.