That sum() SQL is all you do as a user. There is no additional magic there.
The performance numbers are indeed best when data is in memory. However in reality sum() goes over memory mapped file, lazy loading data as required.
The performance numbers are indeed best when data is in memory. However in reality sum() goes over memory mapped file, lazy loading data as required.