Compare row-oriented vs column-oriented storage, page layout, I/O cost, and buffer pool caching
| id | name | age | city | salary |
|---|---|---|---|---|
| 1 | Alice | 28 | NYC | 85,000 |
| 2 | Bob | 34 | SF | 120,000 |
| 3 | Carol | 25 | LA | 72,000 |
| 4 | Dave | 41 | CHI | 95,000 |
| 5 | Eve | 31 | SEA | 110,000 |
| 6 | Frank | 29 | NYC | 88,000 |
| 7 | Grace | 37 | BOS | 102,000 |
| 8 | Hank | 45 | DEN | 78,000 |
Row Store stores entire rows contiguously on disk pages. Great for OLTP (transactional) workloads where you frequently read/write complete rows.
A single page read retrieves all columns for several rows.