Oracle 10g数据库海量数据分页查询优化  

PAGING QUERY OPTIMISATION OF MASSIVE DATA IN ORACLE 10G DATABASE

作　　者：孙风栋[1] 闫海珍[1] 

机构地区：[1]大连东软信息学院计算机科学与技术系,辽宁大连116023

出　　处：《计算机应用与软件》2011年第9期137-139,共3页Computer Applications and Software

摘　　要：Oracle数据库中海量数据分页查询效率直接关系到应用系统的执行效率。介绍Oracle 10g数据库中一种优化的海量数据分页查询解决方案,分析了传统分页查询技术的不足,将数据库优化策略、SQL语句优化、游标变量、批绑定、动态SQL等多种技术融为一体,并提供一个可以共享的、优化的存储过程,提高了海量数据的分页查询效率。Paging query efficiency of massive data in Oracle database directly relates to the execution efficiency of application system in the database.An optimised solution for paging query in Oracle 10g database is presented.After analysing the deficiencies of traditional paging query technique,quite a few technologies are then integrated in a whole,such as database optimisation policy,SQL sentence optimisation,cursor variables,batch binding,dynamic SQL and so on.A shared and optimised storing procedure is presented.All these obviously improve the paging query efficiency of massive data.

关 键 词：分页查询 SQL优化 批绑定 动态SQL 

分 类 号：TP311.132[自动化与计算机技术—计算机软件与理论]