基于表结构及索引的Oracle查询优化研究

Study of Oracle query optimization based on table structure and index

影响Oracie查询效率的因素包括操作系统性能、表结构、索引的合理与否、Oraele参数设置和磁盘速度及使用频度等.任何一个因素,如果没有进行细致的考虑和测试,都有可能造成Oracle查询效率低下甚至使数据库管理系统瘫痪.本文主要是讨论表结构和索引对Oraele查询效率的影响.

The factors effect Oracle query efficiency include operating system performance,table structure, the index reasonable or not, disk speed and the frequency used. For any factor, if considered and tested not carefully, maybe inquires the inefficient of Oracle and even make the database system paralyzed. This paper mainly discussed the influence of table structure and index to Oracle query efficiency.