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;

转载于:https://www.cnblogs.com/vipsoft/archive/2013/03/13/2957299.html