Paging query optimization of massive data in oracle 10g database

Paging query efficiency of massive data directly relates to the execution efficiency of application system in oracle database. Presented an optimized solution for paging query in oracle 10g database, which includes many key technologies,such as database optimization ,SQL optimization, cursor variables, batch binding, dynamic SQL and so on .A shared, optimized stored procedure is issued. Compared with traditional methods, the paging query efficiency of massive data improved obviously.

I. Introduction

As the core product of Oracle Company, the world's largest commercial software vendor, the high performance and high security of Oracle 10g database make it the first choice of backend database in commercial software development. As the increasing of data amount, especially when data reaches massive level (Terabyte, etc.), it becomes an important problem to perform paging query efficiently.