Query Optimization Method of Oracle 9i Database
Liao JianHua · Computer Knowledge and Technology · 2006
The basic tasks of a database are data storage and management, and the only characteristic of the database that terminal users can see is its capability, a database enquiry operation is the impact of the key factors of applications response time. Thus, the query system in a logic and reasonable way is the key to develop database application system successfully. So construct the query system reasonably is a very important link of develop the database application system successfully. This article introduces Oracle enquiries optimization process and its composition based on the indexes, SQL optimization, and other aspects of the measures set out Oracle database enquiries efficiency experience and methods.