SQL Server查询优化器原理与优化实例分析  

Query Optimization Principle and Optimized Instance Analysis of SQL Server

作　　者：刘维学[1] 

机构地区：[1]渤海大学信息科学与技术学院,辽宁锦州121013

出　　处：《计算机技术与发展》2013年第11期108-111,共4页Computer Technology and Development

基　　金：2011辽宁省科学事业公益研究基金(2011004001)

摘　　要：查询是数据库的核心操作,随着数据库技术的发展以及数据量急剧增加,对查询性能的要求越来越高,查询优化成为数据库管理系统亟待解决的重要问题。文中针对应用最广泛的SQL Server数据库的查询优化器进行研究。通过图形研究查询优化器的工作原理,并深入分析提交SQL语句、解析、代数化、查询优化、编译、执行、结果等查询优化器的工作步骤;进行实例分析,运用图形表示了逻辑树和经过优化后得到的查询执行计划。结果表明,SQL语句是查询优化的基础,实际应用时需要写出符合查询优化器规则的SQL语句。The query is the core operation of the database, with the development of database teelmology 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 数据库 查询优化 查询优化器 查询执行计划 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]