Data stored as rows
Ideal for OLTP
Efficient operation on
small set of rows
Improved compression:
Data from same domain compress better
Reduced I/O:
Fetch only columns needed
Improved Performance:
More data fits in memory
Optimized for CPU utilization
Data stored as columns
C5 C1 C2 C3 C4
rowgroup
segment
Ideal for analytics