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.