基于Oracle数据库的SQL语句优化

SQL Optimization Based on Oracle DataBase

该文主要介绍了SQL语句优化技术,并对数据查询语句自身的书写提出一些方法用以优化性能低下的SQL语句。结论表明：对于Oracle这样结构复杂但性能高度可调的数据库,从查询语句的书写这方面进行优化,在不增加软硬件成本投入的情况下,优化效果非常明显,具有一定的实用价值。

This paper is introduced technique of SQL optimization,and puts up some methods on writing data query statement to enhance the low performance SQL lastly.The Findings indicate as follows：For oracle database whose structure is more complicate but the performance height is tunable,Optimizing from writing of data query statement.Without increasing hardware and software cost,the result is significant and is practicable to certain degree.