3 ms·
... also remembering that a traditional dB will typically not store data raw. Row compression is normal and disk compression is normal . The typical column stor
by usgroup 8y ago
... also remembering that a traditional dB will typically not store data raw. Row compression is normal and disk compression is normal . The typical column store advantage is block compression, predicate pushdown and column order storage.
- sixdimensional 8y agoRegular databases such as SQL Server and Oracle have had columnar compression built in as an option along with the row stores for years now. I use it in SQL Server a lot and it works great.