Q1. Assume our query is first. Nothing is in cache.

a) on cursor open: all records satisfying query are read from the file
into temporary buffer on the server

and
b) on fetched: data is moved from the buffer to a clien/client t application


Q2. The same, but it is recordset specific
How is query process related to recordset commands?
oRS.Open and oRS.MoveNext

1)
a) all records satisfying query are read from disk into temporary memory
buffer on the server
( if they are not in cache)
and
b)on MoveNext they are fetched to a client/ a client application

OR

2)
a) list of pointers is built into server memory/tempdb that contains the
position
of datapages in the database file on the disk.
and
b)on MoveNext data is sent from server memory to the client memory


Any references/links are welcome

Thank you in advance,
Andrew