That's pretty accurate. Column-stores also make data compression significantly more effective because they are storing many values of the same type together [1].
The improvements to your first two points are typically 1-2 magnitudes faster with column-stores [2].
Comments
That's pretty accurate. Column-stores also make data compression significantly more effective because they are storing many values of the same type together [1].
The improvements to your first two points are typically 1-2 magnitudes faster with column-stores [2].
[1] http://db.lcs.mit.edu/projects/cstore/abadisigmod06.pdf
[2] http://db.csail.mit.edu/projects/cstore/abadi-sigmod08.pdf