Research about Query Optimization Method of the SQL Server 2005
Gao Xin · Neimenggu Shi-da xuebao. Zhexue shehui kexue hanwen ban · 2012
In view of the practical application of SQL Server 2005 database application system,this paper analyzes the factors that affect the query efficiency of SQL Server 2005 from the aspects of indexing,the SQL statement optimization and stored procedures.The retrieval speed and the system performance can also be improved by using index properly,optimizing the SQL statement reasonable,and using the stored procedures skillfully.