1 Reply Latest reply on Aug 24, 2020 7:40 PM by Vadim Tropashko-Oracle

    Rownum and Fetch next advantages and disadvantages


      i am working on large data and wants to fetch 1000 rows on every iteration so used following queries:

      select * from Base_table where uuid > 325666 and rownum <=1000


      select * from Base_table where uuid >325666 fetch next 1000 rows only


      My question,  what is the advantages and disadvantages of both query and  which one will be good in terms of performance.