Question and suggestion regarding rownum

Hi! Folks

I am sure many of you have come across this problem which I am facing and hope to have some suggestions.
We have an web application with tones of where clauses and group by but eventually the result set could be any where from 1 to 10000. Now the web page would display only 1 to 10 items after which if you would click on next it would show from 11 to 20 - till here it is some what do able - the problem lies when the user click on directly 45th page which should show records from 2000 onwards. I was thinking of using the rownum function .. remember this is a select from a 500K table - .

Any folks who have a better idea or suggestion would be great ful.

Thanks
Ketan Received on Thu Nov 13 2003 - 00:40:51 CST