A DESCRIPTION OF THE REQUEST :
I need obtain a complete fecth of 1000 rows. I need access with 10 thread

at time:
1st thread 1 100
2nd thread 101 to 200

...

This could improve performance of my applications.

JUSTIFICATION :
If I need make this I need use another language like C, read one row at a time is slow.

EXPECTED VERSUS ACTUAL BEHAVIOR :
EXPECTED -
I like that resultset could be indexes by row.


ACTUAL -
Only I could read a row at time. and sequencially

CUSTOMER SUBMITTED WORKAROUND :
I make a C program that does this.