Yes, BUT. For analytical workloads you often want the locality to be within columns, and not within rows, we call these things column stores ;). Database desig

Yes, BUT. For analytical workloads you often want the locality to be within columns, and not within rows, we call these things column stores ;). Database design has many tradeoffs, and there is no free lunch.