数据库查询优化方法的研究与探索  

Research and exploration of database querying optimization method

作　　者：刘玉红 王俊峰[2] 

机构地区：[1]乌鲁木齐市教育招生考试中心,新疆乌鲁木齐830002 [2]重庆电子工程职业学院,重庆401331

出　　处：《电子设计工程》2012年第14期66-68,共3页Electronic Design Engineering

摘　　要：SQL是一种数据库查询和程序设计语言,用于存取数据以及查询、更新和管理关系数据库系统。不同的实现方法之间可能存在的性能差异,这种性能差异在大型的或是复杂的数据库环境表现得尤为明显。不良的SQL往往来自于不恰当的索引设计、不充分的连接条件和不可优化的where子句。文中通过对SQL查询语句的优化方法研究,提出了具体的优化策略。SQL is a programming language designed for accessing and manipulating databases.Although SQL is an ANSI standard,there are many different versions of the SQL language.Performance differs between versions due to different implementation methods,and the difference between large or complex database management systems is particularly obvious.Bad SQLs are often due to inappropriate index designs,inadequate join conditions and ＂where＂ clauses that can not be optimized.In this paper,Specific optimization strategies are proposed with SQL query optimization methods research.

关 键 词：性能优化 查询 查询效率 安全性 

分 类 号：G202[文化科学—传播学]