Analysing the effect of the index upon query capability on SQL Sever 2000
Xuguang Qiu · Control Engineering of China · 2003
In this paper by explaining the principles of query optimizer, we Introduce how to optimize the different query statement and index . In the end we give the disciplinarians about designing index and programing optimized query.