Rows vs Columns
Workload for different operations
- insert requires more work in CoDbs
- row: update one page; column: update multiple pages
- project comes "for free" in CoDbs
- row: extract fields from each tuple; column: merge columns
- select may require less work in CoDbs
- row: read whole tuples; column: read just needed columns
- join may require less work in CoDbs
- row: hash join; column: scan columns for join attributes
|