| 数据库查询优化方法的研究与探索 |
| |
| 引用本文： | 刘玉红,王俊峰.数据库查询优化方法的研究与探索[J].电子设计工程,2012,20(14):66-68. |
| |
| 作者姓名： | 刘玉红 王俊峰 |
| |
| 作者单位： | 1. 乌鲁木齐市教育招生考试中心,新疆乌鲁木齐,830002
2. 重庆电子工程职业学院,重庆,401331 |
| |
| 摘 要： | SQL是一种数据库查询和程序设计语言,用于存取数据以及查询、更新和管理关系数据库系统。不同的实现方法之间可能存在的性能差异,这种性能差异在大型的或是复杂的数据库环境表现得尤为明显。不良的SQL往往来自于不恰当的索引设计、不充分的连接条件和不可优化的where子句。文中通过对SQL查询语句的优化方法研究,提出了具体的优化策略。
|
| 关 键 词： | 性能优化 查询 查询效率 安全性 |
Research and exploration of database querying optimization method |
| |
| LIU Yu-hong,WANG Jun-feng.Research and exploration of database querying optimization method[J].Electronic Design Engineering,2012,20(14):66-68. |
| |
| Authors: | LIU Yu-hong WANG Jun-feng |
| |
| Affiliation: | 1.Urumqi City Board of Education Entrance Examination Center,Urumqi 830002,China; 2.The Chongqing Institute of Electronic Engineering Occupation,Chongqing 401331,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | performance optimization query query efficiency security |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
