Resultset Paging & Performance increase using ROWNUM

[chrisrlong]

Buggers. My post got cut off as well. I apologize for assuming you posted the statement incorrectly. Let's try this again:

SELECT *
FROM table1
WHERE conditon AND
rownum>X AND
rownum<Y