基于Oracle 9i数据库的查询优化

数据库的任务是存储和管理数据,而用户能看到的有关数据库特性就是它的性能,数据库的查询操作是影响一个应用系统响应时间的关键因素。科学合理地构造查询系统,是成功开发数据库应用系统非常重要的环节。该文主要介绍Oracle9i的查询优化程序及其组成,从基于索引、SQL优化、以及其它措施各个方面阐述了Oracle9i数据库查询效率提高的经验和方法。

Query Optimization Method of Oracle 9i Database

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.