• DocumentCode
    2624136
  • 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
  • fYear
    2011
  • fDate
    27-29 June 2011
  • Firstpage
    2388
  • Lastpage
    2391
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Computer Science and Service System (CSSS), 2011 International Conference on
  • Conference_Location
    Nanjing
  • Print_ISBN
    978-1-4244-9762-1
  • Type

    conf

  • DOI
    10.1109/CSSS.2011.5974879
  • Filename
    5974879
    • Link To Document
    https://search.isc.ac/dl/search/defaultta.aspx?DTC=49&DC=2624136