| 基于SQL中的查询优化策略研究 |
| |
| 引用本文： | 单光庆,程书红.基于SQL中的查询优化策略研究[J].电子测试,2008(1):15-19. |
| |
| 作者姓名： | 单光庆 程书红 |
| |
| 作者单位： | 重庆城市管理职业学院学电子信息工程系,重庆,400055 |
| |
| 摘 要： | 查询是数据库中最基本、最常用、最复杂的操作,查询操作的优劣直接影响数据库应用程序的性能.为了提高数据库应用系统的执行效率,本文以关系数据库为基础,从分析关系数据库系统查询处理过程入手,结合自己的实践经验,从数据库设计和查询策略选择的角度来讨论查询优化技巧,指出关系数据库查询优化的一般原则.本文主要讨论了基于SQL查询重写技术的数据库查询优化策略,通过查询重写可以把用户所写的效率不高的SQL语句重新优化组合,使之成为效率较高的查询语句.
|
| 关 键 词： | 关系数据库 查询重写 策略 效率 |
Research of inquiry optimization strategy based on SQL |
| |
| Shan Guangqing,Cheng Shuhong.Research of inquiry optimization strategy based on SQL[J].Electronic Test,2008(1):15-19. |
| |
| Authors: | Shan Guangqing Cheng Shuhong |
| |
| Affiliation: | Shan Guangqing,Cheng Shuhong(Electronic Information Engineering Department,Chongqing City Management Professional Institute,Chongqing 400055,China) |
| |
| Abstract: | The inquiry is the most basic, commonly used, the most complex operation in the database. Inquiry operation fit and unfit quality direct influence database application procedure performance. In order to enhance the database application system to carry out the efficiency, This article takes the relational database as a foundation, from analysis relational database system inquiry treating processes obtaining, unifies oneself experience, discusses from the database design and the inquiry strategy choice angle ... |
| |
| Keywords: | relational database inquiry recomposition strategy efficiency |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
