Day 8 drills

Written on paper first. Pages, row width, and row store vs column store.

D1 (200-byte rows, 8 KB pages: rows per page, bytes read for one 4-byte field):

D2 (10M rows at 200 bytes: table size, page count, scan time at 500 MB/s):

D3 (sum one 8-byte column over 1B rows of 500 bytes: row store vs column store bytes, ratio):

D4 (classify four queries as OLTP/row store or OLAP/column store):

D5 (8 KB vs 16 KB pages: what gets better, what gets worse, the tradeoff):