数据库分页优化技术分析与实现

Analysis and Implementation of Paging Optimization in Database

基于Oracle作为后台数据库,在分析普通的查询方式后,提出了一种新的优化查询方法——索引扫描分页技术,通过试验分析,优化后的查询方法在实现分页显示的操作中有明显的提高。

Based on Oracle as the backend database, in the-form of a-general inquiry, the paper proposes a new optimization query method - an index scan paging technology, through test and analysis, optimized query methods to achieve improved significantly in paging operation.