| Oracle 10g数据库海量数据分页查询优化 |
| |
| 引用本文： | 孙风栋,闫海珍.Oracle 10g数据库海量数据分页查询优化[J].计算机应用与软件,2011(9). |
| |
| 作者姓名： | 孙风栋 闫海珍 |
| |
| 作者单位： | 大连东软信息学院计算机科学与技术系; |
| |
| 摘 要： | Oracle数据库中海量数据分页查询效率直接关系到应用系统的执行效率。介绍Oracle 10g数据库中一种优化的海量数据分页查询解决方案,分析了传统分页查询技术的不足,将数据库优化策略、SQL语句优化、游标变量、批绑定、动态SQL等多种技术融为一体,并提供一个可以共享的、优化的存储过程,提高了海量数据的分页查询效率。
|
| 关 键 词： | 分页查询 SQL优化 批绑定 动态SQL |
PAGING QUERY OPTIMISATION OF MASSIVE DATA IN ORACLE 10G DATABASE |
| |
| Sun Fengdong Yan Haizhen.PAGING QUERY OPTIMISATION OF MASSIVE DATA IN ORACLE 10G DATABASE[J].Computer Applications and Software,2011(9). |
| |
| Authors: | Sun Fengdong Yan Haizhen |
| |
| Affiliation: | Sun Fengdong Yan Haizhen(Department of Computer Science and Technology,Dalian Neusoft Institute of Information,Dalian 116023,Liaoning,China) |
| |
| Abstract: | 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 presente... |
| |
| Keywords: | Paging query SQL optimisation Batch binding Dynamic SQL |
| 本文献已被 CNKI 等数据库收录！ |
|
