摘要
随着数据的爆炸式增长以及人们对数据处理效率的更高要求,数据库性能优化的重要性达到前所未有的高度。尤其在数据库存储大规模数据时,性能问题可能非常严重。而数据库性能往往对应用程序性能影响最大,所以是需要首先解决的问题。基于Oracle的应用程序很多性能问题都是由SQL性能低劣引起的。针对数据库性能日趋重要却越发低下的问题,着重介绍目前Oracle中的索引、表分区、优化器模式等几种常见的数据库优化方法。
With the unbelievably and rapidly increasing development of data and higher requirements on data processing efficiency, great emphasis has been put on database performance optimization. Extremely serious performance problems might occur especially in a database with massive data. Database performance problems should be first solved as it probably has greatest effect on application program performance. Many performance problems in database-centric applications are caused by inefficient SQL statements. The database performance is becoming more and more important but inefficient. Introduces several common database optimization methods such as index, table partition and optimizer mode, discusses the applications of oracle databases with massive data.
出处
《现代计算机》
2012年第24期45-48,共4页
Modern Computer
关键词
ORACLE
性能优化
SQL语句
索引
优化器模式
Oracle
Performance Optimization
SQL Statements
Index
Optimizer Mode
Massive Data
