Rows vs Columns: How different are they, really?
Connor Tsui,
Spiral,
Nov 20, 2026
This is the sort of thing that keeps me wondering. Storing data in rows is importantly different from storing it in columns. It's not just a conceptual difference; it is a difference in where the bits are physically placed in a storage medium, and that has an impact on how efficient it is to make one sort of query rather than another. Suppose I am storing information about bicycle rentals. If I want to know about a particular rental (in order to, say, invoice a customer) then a row is more efficient. But if I'm doing analytics (in order to, say, assess demand in a certain region) then a column is more efficient. Anyhow, this article explores the implications of that, describes the different types of databases, and dips into more advanced topics like 'vectorized execution'.
Today: Total: [] [Share]

