海量数据分页(高手进,分不够加!!)
小弟,最近在用oracle 做分页,使用
======================================
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
================================
目前数据库中有千万数据,此语句随着页数的增加越来越慢,点击"尾页"时,要等很长时间,请高手告知解决办法!!!