浅谈Oracle数据库SQL调整与优化  

Introduction to the Oracle Database SQL Adjustment and Optimization

作　　者：孟津平 李易东 Meng Jin-ping;Li Yi-dong(Changchun University of Science and Technology , School of Computer Science and Technology, Changchun Jilin 130012)

机构地区：[1]长春理工大学计算机科学技术学院,吉林长春130012

出　　处：《数字技术与应用》2018年第3期217-217,219,共2页Digital Technology & Application

摘　　要：随着数据库规模的不断扩大,数据库系统的性能问题也越来越突出,数据库能否正常高效地运行备受关注,因此数据库优化技术的研究具有极其重要的意义。本文主要介绍数据库SQL语句的优化以及索引应用中的错误。With the continuous expansion of the database, the problem of the performance of the database system is becoming more and moreserious, the database can be normal and efficient operation, much attention has been paid so database optimization technology research is of greatsignificance.This paper mainly introduces errors in the database application and the optimization of SQL statements as well as the index.

关 键 词：SQL语句优化 索引限制 Oracle优化思路 

分 类 号：TP311.138[自动化与计算机技术—计算机软件与理论]