Title :
Paging query optimization of massive data in oracle 10g database
Author :
Sun, Fengdong ; Wang, Lan
Author_Institution :
Dept. Of Comput. Sci. & Technol., DaLian Neusoft Inst. of Inf., Dalian, China
Abstract :
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.
Keywords :
SQL; optimisation; query processing; SQL optimization; batch binding; cursor variables; database optimization; massive data; oracle 10g database; paging query optimization; query efficiency; Dictionaries; Indexes; Memory management; Optimization; Servers; Sorting; Batch binding; Dynamic SQL; Paging Query; SQL Optimization;
Conference_Titel :
Computer Science and Service System (CSSS), 2011 International Conference on
Conference_Location :
Nanjing
Print_ISBN :
978-1-4244-9762-1
DOI :
10.1109/CSSS.2011.5974879
