Oracle 分页
1267715条数据,每页10条
1.【第999980~999990页 0.327】【推荐】
下图为测试第一页的时间
SELECT ID, NAME, IDCARD, GENDER, STAR FROM Users WHERE ROWID IN (SELECT RID FROM (SELECT ROWNUM RN, RID FROM (SELECT ROWID RID FROM Users ORDER BY ID DESC) WHERE ROWNUM < =10) WHERE RN > 0) ORDER BY ID DESC;
2.【第999980~999990页 5.039】【随着页数的增加,会变慢】
下图为测试第一页的时间
SELECT * FROM (SELECT ROW_.*, ROWNUM RN FROM (SELECT ID, NAME, IDCARD, GENDER, STAR FROM Users ORDER BY ID DESC) ROW_ WHERE ROWNUM <=10) WHERE RN > 0;
本文来自博客园,作者:VipSoft 转载请注明原文链接:https://www.cnblogs.com/vipsoft/archive/2013/03/13/2957299.html