摘要
Oracle系统结构复杂,性能受多方面因素影响,性能的调整是一项系统工程,因此必须通过优化措施保证数据库以最优的性能运行。文章分析了Oracle9i的索引原理,并阐述了如何建立有效的索引以及根据USER_INDEXES视图进行分析以优化Oracle9i的工作性能。
The Oracle9i has a complex architecture.Many reasons can affect the performance of the system.Tuning the Oracle is a systems engineering.Therefore it must make sure that the system is running well by optimized means.This paper analyzes Oracle9i indexing theory and introduces how to build effective indexes and how to analyze it through the USER_INDEXES view to maximize oracle 9i performance.
出处
《计算机工程与应用》
CSCD
北大核心
2005年第26期174-176,共3页
Computer Engineering and Applications
基金
国家科技部重点专项项目(编号:2002DEA30029)
