Research of optimization rule of SQL based on Oracle database
Jin Hua Zhou · Journal of Shaanxi University of Technology · 2013
The SQL of query execution principle and process in the Oracle database,were researched with the example of a current database in the system called International Standard Book Number(ISBN),and analyzed the execution plan of the executed SQL statement.From the process of execution related to the resources of system and the way optimized the SQL statement,and at the last,a series of rules of SQL optimization were obtained and proved based on the result of the optimization.