🗄️Columnar Storage
Also known as Column-Oriented Storage, Columnar Database, Column Store
A table kept one column at a time. A report reads just the columns it needs.
Think of it like
It is like a class list sorted by subject. All the math marks sit together, so adding them up is quick.
Example
A sales table has 50 columns. A query for total sales by month reads just the date and amount columns, a tiny part of the file.
Why it matters
It is why warehouses can scan billions of rows in seconds. Less data read means faster and cheaper queries.
Definition
Common mistake
Key takeaways
- 1Columns together. Each column is stored on its own.
- 2Read less. Skip the columns a query does not need.
- 3Squeezes well. Like values pack down small.