Hello,

I have different requirement of performing scan/search on a large table with 100000 records in it.

My requirement is to perform as below:

Step 1: Begin Transaction 1:
step 2: Read 0-300000 tuples.
step 3: commit transaction 1.

Step 4: Begin Transaction 2
Step 5: Read 300001- 100000 tuples.
step 6: commit transaction 2.

My question is - is there a way step 5 can be performed. I am not sure of any database does support it.
Basically, i am looking at reading some x number of tuples in transaction 1 and in transaction 2 want to read the remaining number of tuples from the last tuple which was read in transaction 1 till the end of the table.

Any response is appreciated.