The DBMS stores the values of a single attribute for all tuples contiguously in a page
-> Also known as a "column store"
Ideal for OLAP workloads where read-only queries perform large scans over a subset of the table's attributes.
Reduce the amount wasted I/O because the DBMS only reads the data that it needs
Better query processing and data compression (more on this later)
Slow for pointer queries, inserts, updates, and deletes because of tuple splitting/stitching
Last updated 3 years ago