海量级表翻页 可以采用如下方式,此方式看似复杂,但是如果是海量级的表 相比其他翻页方式,要快的多
SELECT party_id, NAME, default_id_type, address_str
FROM (SELECT RID
FROM (SELECT R.RID, ROWNUM LINENUM
FROM (SELECT ROWID RID FROM crm.party@link_bssha) R
WHERE ROWNUM <= 2096590)
WHERE LINENUM >= 2092590) T1,
crm.party@link_bssha T2
WHERE T1.RID = T2.ROWID;