摘要
Oracle数据库是当前应用最广泛的大型数据库之一,其系统结构复杂,性能受多方面因素影响,其中查询操作是影响其性能的关键因素。为了提高Oracle数据库查询效率,本文通过分析Oracle处理查询语句的过程以及优化器的工作原理,结合实例,讨论了Oracle数据库查询优化的多种有效方法。
Oracle is one of the most widely used large-scale databases at present. For its complex architecture, Oracle＇ s performance is subjected to various factors, and query operation is one of the key factors. To improve the efficiency of Oracle query, the paper discusses various effective methods by analyzing how query statement is processed and the principle of optimizer, giving some examples.
出处
《计算机与现代化》
2008年第4期4-7,共4页
Computer and Modernization
基金
黑龙江海外学人科研启动基金资助项目(1055HQ036)
