摘要
随着信息时代的不断发展,人们在工作、学习和生活中越来越离不开数据。大量的数据存储在数据库中,通过SQL语言被应用程序调用,对SQL语句进行优化处理,可以大大提高系统的性能。本文首先分析了Oracle数据库的执行过程和查询机制,其次对SQL优化系统进行了分析,描述SQL优化规则验证,分析了整个优化系统的流程。本文对于数据库研发人员具有一定的积极作用。
With the development of information, people cannot do anything without data in work, study and life. A large amount of data is stored in the database, application software use the SQL language, to optimize the SQL statement, can greatly improve the performance of the system. This paper first analyzes the implementation process and the query mechanism of Oracle database; secondly has carried on the analysis to the optimization of SQL system, describes the SQL optimization rules verification, analyzed the optimization system of process, ensure the operation safety and reliability, This Daoer has certain Dositive role for the database develnner.
