Query optimization based on the SQL Server

摘要：

The purpose of this paper is to improve the execution efficiency of SQL query statements in the DBMS of SQL Server. First we discussed the query statements in SQL Server, then we concluded some useful and efficient methods for query optimization in the SQL Server from two aspects: query optimization based on the index mechanism and query optimization based on the rewrite of query statements. In the end, we proved the methods above could enhance the efficiency of query statements significantly.

关键词： SQL Server query optimization index mechanism query statements

作者: WEI Xin GUO Bing

作者单位: College of Software Sichuan University Chengdu,China College of Computer Science Sichuan University Chengdu,China

会议类型: 国际会议

会议名称: 2011 3rd International Conference on Computer and Network Technology(ICCNT 2011)(2011第三届IEEE计算机与网络技术国际会议)

会议地点: 太原

会议语种:英文

页码: 156-158

在线出版日期: 2011-02-26（万方平台首次上网日期，不代表论文的发表时间）