关于Oralce数据库的SQL查询语句优化探究

Research on Optimization of SQL Query in Oralce Database

Oralce数据库具有明显超越普通数据库的性能, 不仅提升了存储空间, 也扩大了使用范围.在一些大型数据库研究中, 优质的SQL查询语句和劣质的SQL查询语句之间的速度差别很有可能达到上百倍之多.为了更好地缩短大数据量的信息查询和处理时间, 提升数据库应用系统的工作效率, 实现对Oralce数据库中SQL查询语句的优化具有非常重要的意义.

The Oralce database has the performance that obviously surpasses the common database, not only improves the storage space but also expands the scope of use. In the study of some large databases,speed differences between high-quality SQL queries and low-quality SQL queries are likely to be as much as hundreds of times. In order to achieve a better shorten the time of information query and processing of large amount of data and improve the efficiency of database application system, it is very important to optimize the SQL query in Oralce database.