| 基于索引的SQL语句优化方法探讨 |
| |
| 引用本文： | 张诗雨,陈汶滨. 基于索引的SQL语句优化方法探讨[J]. 计算机与现代化, 2009, 0(3) |
| |
| 作者姓名： | 张诗雨 陈汶滨 |
| |
| 作者单位： | 西南石油大学计算机科学学院,四川,成都,610500 |
| |
| 摘 要： | 针对提高软件运行性能的方法之一SQL语句的优化,主要介绍了SQL语句的执行过程,以及在SQL语句执行过程中优化器是如何利用索引进行优化的,总结了建立索引的策略,以及如何使用索引器优化SQL语句.
|
| 关 键 词： | SQL语句 优化 索引 |
Discussion on Method Optimizing Index-based SQL |
| |
| ZHANG Shi-yu,CHEN Wen-bin. Discussion on Method Optimizing Index-based SQL[J]. Computer and Modernization, 2009, 0(3) |
| |
| Authors: | ZHANG Shi-yu CHEN Wen-bin |
| |
| Affiliation: | Computer Science College;Southwest Petroleum University;Chengdu 610500;China |
| |
| Abstract: | In respect of SQL optimization,one of the methods to improve software's performance,this essay mainly introduces an executing process of SQL at first,in which process,then how optimizer uses index to optimize.Lastly,the essay sums up the strategy to build up index and how to use it to optimize SQL. |
| |
| Keywords: | SQL optimization index |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
