Organizational Research By

Surprising Reserch Topic

oracle faster paging query


oracle faster paging query  using -'oracle'

I have two paging query that I consider to use.

First one is

SELECT * FROM ( SELECT rownum rnum, a.* from (
    select * from members
) a WHERE rownum <= #paging.endRow# ) where rnum > #paging.startRow#


And the Second is

SELECT * FROM ( SELECT rownum rnum, a.* from (
    select * from members
) a ) WHERE rnum BETWEEN #paging.startRow# AND #paging.endRow#


how do you think which query is the faster one?
    
asked Oct 6, 2015 by santosh soni
0 votes
7 views



Related Hot Questions



Government Jobs Opening


...