oracle分页大数据量查询慢

name: oracle 分页大数据量慢
about: 数据量1000w左右查询非常耗时

select * from tableA  order by update_time desc;

select *
from (select ROWNUM ROW_ID, *,
from table
WHERE ROWNUM <= 25) as TMP_PAGE
WHERE TMP_PAGE.ROW_ID > 0;

选择 Oracle9iDialect 实现即可。

<property name="dialectAlias" value="oracle=com.github.pagehelper.dialect.helper.Oracle9iDialect"/>

abel533 / Mybatis_PageHelper