摘要
针对提高软件运行性能的方法之一SQL语句的优化,主要介绍了SQL语句的执行过程,以及在SQL语句执行过程中优化器是如何利用索引进行优化的,总结了建立索引的策略,以及如何使用索引器优化SQL语句。
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.
出处
《计算机与现代化》
2009年第3期134-136,共3页
Computer and Modernization