| 基于索引的SQL语句查询优化方法的研究 |
| |
| 引用本文： | 刘晓平.基于索引的SQL语句查询优化方法的研究[J].韶关学院学报,2006,27(12):27-30. |
| |
| 作者姓名： | 刘晓平 |
| |
| 作者单位： | 韶关学院 计算机系,广东 韶关 512005 |
| |
| 摘 要： | 查询是数据库中最基本、最常用的操作,而查询优化是数据库性能优化最为重要的手段之一.以索引技术为研究手段,介绍了索引的工作原理及索引类型,提出了建立索引的基本原则.通过举例,重点讨论了基于索引的SQL语句优化方法,以达到提高系统性能的目的.
|
| 关 键 词： | SQL语句 索引 查询优化 |
| 文章编号： | 1007-5348(2006)12-0027-04 |
| 收稿时间： | 06 27 2006 12:00AM |
| 修稿时间： | 2006年6月27日 |
The methods of SQL sentences' optimization on index |
| |
| LIU Xiao-ping.The methods of SQL sentences'''' optimization on index[J].Journal of Shaoguan University(Social Science Edition),2006,27(12):27-30. |
| |
| Authors: | LIU Xiao-ping |
| |
| Institution: | Department of Computer, Shaoguan University, Shaoguan 512005, Guangdong, China |
| |
| Abstract: | Enquiry is the most basic and frequently used operation in the database,and query optimization have become one of the most important meanses on the performance of database.The index principle and index type are introduced by index technique.The principia of upbuilding index is put forward.Through example, the way of optimization in sql sentences is discussed and for all of this can improve the system performance. |
| |
| Keywords: | SQL sentence index query optimization |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
