[AccessD] Access and SQL Server - Where is the work done - How Many Rows are Shipped Across the Network

All,

This is just a curiosity question.

Let's say that I have an Access application that obtains data from a SQL Server database via ODBC.

There are 1,000,000 rows in one of the SQL Server tables.

There is a query in the Access application that returns 100 rows from this table based on the "Where" condition in the query.

I would guess that the "heavy lifting" is being done by the SQL Server database box and only 100 rows are shipped back to the Access application on the PC.

Is this correct?

Is this always the case, or is it possible that all of the 1,000,000 rows are sent back to the Access application depending on the complexity of the SQL?

Again, these are just curiosity questions.

Thanks,
Brad