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.