当前位置: 首页 > 文章 > 基于ORACLE成本优化器的SQL查询优化分析与应用 内蒙古农业大学学报(自然科学版) 2018 (2) 88-93
Position: Home > Articles > SQL QUERY OPTIMIZATION AND APPLICATIONBASED ON ORACLE COST OPTIMIZER Journal of Inner Mongolia Agricultural University(Natural Science Edition) 2018 (2) 88-93

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

作  者:
魏玉芬;王玥
单  位:
黑龙江八一农垦大学理学院
关键词:
Oracle数据库;Sql;成本优化器
摘  要:
SQL语句是操控和访问数据库的唯一语言,因此对SQL执行策略的优化,可以缩短响应时间、降低CPU使用率、显著地改善数据库系统及应用系统的性能。本文通过对SQL查询进行索引优化调整和分区优化调整,优化索引和分区结构,制定优化执行策略,以减少成本输出,降低CPU使用率,减少磁盘I/O,提高数据库查询的执行效率,并利用实例进行优化验证。
译  名:
SQL QUERY OPTIMIZATION AND APPLICATIONBASED ON ORACLE COST OPTIMIZER
作  者:
WEI Yufen;WANGYue;College of Science,Heilongjiang Bayi Argriculture University;
关键词:
Oracle database;;sql;;cost-based optimizer
摘  要:
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.

相似文章

计量
文章访问数: 8
HTML全文浏览量: 0
PDF下载量: 0

所属期刊

推荐期刊