| 基于SQL语句查询优化分析的研究 |
| |
| 引用本文： | 董萍,马新荣.基于SQL语句查询优化分析的研究[J].河北职业技术学院学报,2007,7(6):17-18. |
| |
| 作者姓名： | 董萍 马新荣 |
| |
| 作者单位： | 三门峡职业技术学院,河南,三门峡,472000 |
| |
| 摘 要： | 计算机应用系统的真正目的不是简单地实现其功能,而是要写出高质量的SQL语句,提高系统的可用性。SQL语句查询优化的实质就是在结果正确的前提下,优化器根据定义的索引来提高查找效率,尽量避免全表扫描的发生。本文主要从SQL语句的优化原因及过程方面进行阐述。
|
| 关 键 词： | SQL DBMS 优化 查询 |
| 文章编号： | 1671-1017（2007）06-0017-02 |
| 修稿时间： | 2007-06-28 |
Based on SQL Sentence Inquiry Optimization Analysis Study |
| |
| DONG Ping,MA Xin-rong.Based on SQL Sentence Inquiry Optimization Analysis Study[J].Journal of Hebei Polytechnic,2007,7(6):17-18. |
| |
| Authors: | DONG Ping MA Xin-rong |
| |
| Institution: | DONG Ping MA Xin-rong |
| |
| Abstract: | Computer application system's real purpose is not can realize function simply,but can write the height mass SQL sentence,improve systematic applicability.The essence of the SQL sentence inquiry is on the premise of result rightness,according to defined index optimize an implement can improve seeking efficiency,and avoid the occurrence of the whole scans.This essay is mainly expounded from SQL sentence optimization's cause and process. |
| |
| Keywords: | SQL DBMS optimization inquiry |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
