SQL语句优化方法分析

Analysis of SQL Statement Optimization

随着数据库应用系统中数据的增加,系统的响应速度成为系统设计需要解决的主要问题。由于用户对数据库的查询效率要求越来越高,因此必须对数据库进行优化。系统优化的一个很重要的方面就是SQL语句本身的优化,从应用的角度论述了SQL语句的优化方法。

In database application systems, performance becomes one of their main problems to be resolved with the increase of data in it. For the demands that the customer wants the database more and more effective, we must optimize the design of the database. SQL optimization is a very important aspect in system optimization. This paper states some methods of SQL optimization from the application aspect.