First, I dont think rowunm > N will work.

If you have given rownum < 100 then oracle fetches upto 100 and stops. You can find out this by doing explain plan of the sql statement(COUNT (STOPKEY)).

The read from the table is based on the DB block. It might fetch upto say 150 rows and return 100 rows out of it.

Hope this helps.