Paging query optimization of massive data in oracle 10g database
Fengdong Sun, Lan Wang · 2011
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.