摘要: 随着数据量的不断增加,数据库的分页查询效率成为提高数据库访问性能的重要问题。从分析影响分页查询速度的关键因素入手,结合优化器中SQL语句的优化原理和分页算法,通过理论推导和实验结果的分析,提出分页查询优化的设计方法。将该方法应用于实际系统的分页框架中,取得了较好的效果。
关键词:
优化器,
查询优化,
分页框架
Abstract: With the increasing amount of data, paging query efficiency of database becomes an important issue to improve the access performance of database. This paper begins with the analysis of key factors which impact the speed of paging query, combining with the optimization theory of SQL statement in the optimized device and paging algorithms, and through the analysis of theoretical infers and experimental results, to point out design methods of paging query optimization. It achieves good results to imply the methods into paging framework of actual systems.
Key words:
optimizer,
query optimization,
paging framework
中图分类号:
李 辉;王瑞波. 多条件分页查询优化的设计方法[J]. 计算机工程, 2010, 36(2): 51-52.
LI Hui; WANG Rui-bo. Design Methods of Multi-condition Paging Query Optimization[J]. Computer Engineering, 2010, 36(2): 51-52.