Answer
Row store: row-by-row storage; best for OLTP.
Column store: column-by-column storage; best for analytics, high compression, parallel execution.
Quick Answer
Row store organizes data by rows — all columns for a row are stored together. Good for OLTP (point lookups, row modifications). Column store organizes data by column — ideal for analytics where queries read a few columns across millions of rows. Column store also compresses heavily and enables batch-mode processing.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ