摘要
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.
出处
《计算机应用与软件》
CSCD
2011年第9期137-139,共3页
Computer Applications and Software