To further extend the discussion on rownum
I need 500 to 600 of 100000 records selected displayed on my page . The user can naviaget through the pages in increments of 100 rows .
here 100000 is the total number of records
of which I am displaying 500 - 600
ordered on some column ,
What is the optimal solution here?
We use scrollable result set in Java . But I hear that in the above case all 100000 records have to be transfered across the wire .
Is it better to d two queries one for the details of the rows and other for count ?
Someone suggested that inline views are very slow and degrades performance. Is this true ?
