计算机技术与发展Issue(11)：108-111,4.DOI:10.3969/j.issn.1673-629X.2013.11.027
SQL Server查询优化器原理与优化实例分析
Query Optimization Principle and Optimized Instance Analysis of SQL Server
摘要
Abstract
The query is the core operation of the database,with the development of database technology and the dramatic increasing in a-mount of data,increasingly high demand on the query performance,query optimization becomes important issue that needs to be solved of database management system. It studies the query optimizer that the most widely used in SQL server database. Above all,research query optimizer's working principle through graph,penetrate deeply analysis of query optimizer's work steps by submitting SQL statements, parsing,algebrization,query optimization,compile,query execution,query results and so on;then,execute instance analysis,use graphics for representation of the logic tree and optimized query execution plan. The result shows that the SQL statements are the basis of the query optimization,practical application needs to write SQL statements that match the query optimizer rules.关键词
SQL Server/数据库/查询优化/查询优化器/查询执行计划Key words
SQL Server/database/query optimization/query optimizer/query execution plan分类
信息技术与安全科学引用本文复制引用
刘维学..SQL Server查询优化器原理与优化实例分析[J].计算机技术与发展,2013,(11):108-111,4.基金项目
2011辽宁省科学事业公益研究基金(2011004001) （2011004001）
