基于ORACLE成本优化器的SQL查询优化分析与应用

SQL QUERY OPTIMIZATION AND APPLICATIONBASED ON ORACLE COST OPTIMIZER

SQL语句是操控和访问数据库的唯一语言,因此对SQL执行策略的优化,可以缩短响应时间、降低CPU使用率、显著地改善数据库系统及应用系统的性能。本文通过对SQL查询进行索引优化调整和分区优化调整,优化索引和分区结构,制定优化执行策略,以减少成本输出,降低CPU使用率,减少磁盘I/O,提高数据库查询的执行效率,并利用实例进行优化验证。

SQL statement is manipulating the only language and access database. it can significantly improve the performance of database system and application system through Optimize SQL execution strategy,shorten response time,reduce the CPU usage. In this article,Using the method of index optimization adjustment and partition optimization for sql,Optimize the structure of index and partition,Optimal execution strategy,In order to reduce the cost of the output,reduce the CPU utilization,reduce disk I/O,improve the execution efficiency of database query,and it＇s optimized by practical example.