Hi,
I want to know can I assume that , when the sorting is not specified, the rows are returned sorted by rowid ?
Or, in other words :
I execute : select * from table , on some very huge table, in.net, using DataReader
While fetching, I remember rowid of the last row.
After some time, because of an exception, or lost connection, or whatever, the fetch is over.
I know that last processed rowid was XXXXX
Now I want to process the rest of the table , and my question is:
can I reexecute now : select * from table where rowid>XXXXX
woud this garantie that no one row will be missed, and also no one row will be processed twice ?
The ' order by ' is not an option in this case, because the table is huge that it will take big time.
Is there any other ( better ) option to read a huge table as fast as possible and also to be able to continue when the process is interapted because of any reason ?