SQL Optimization Based on Oracle Database
The problem of database performance has been the focus that decision makers and technicians pay attention to and an important factor that impacts database performance is the low efficiency of the SQL query statements. This paper discusses the execution, parsing procedure and the basic principle of SQL statements and the common reasons why the SQL query statements is low efficiency, and the common steps of optimizing SQL. It also analyses how to optimize the operation of database access and how to improve the query efficiency when several tables connected. Finally, it realizes the optimization of SQL based on oracle database.
Oracle SQL statement parse optimizing performance
Qitao Zhang
Department of Computer and Information Engineering Harbin University of Commerce Harbin, China
国际会议
重庆
英文
255-259
2011-01-21（万方平台首次上网日期，不代表论文的发表时间）