I need to do SELECT query from java code on table that contains 1kkk rows , so the result set will be near 1kk rows. thats why I need to limit it, and run select query many times and each time to retrieve 10k rows only. After I get 10k rows I update it so in the next SELECT they wont be retrieved.
The problem is - in each select oracle looking from first row in the table so it reduces the performance.
How can I use OFFSET for avoiding oracle looking from first row and pass over already updated rows?
The problem is - in each select oracle looking from first row in the table so it reduces the performance.
How can I use OFFSET for avoiding oracle looking from first row and pass over already updated rows?
Comment