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

    Rownum and Fetch next advantages and disadvantages

    bac15c63-e3fd-4ed0-a5fe-2dacb0fecfa3

      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.