4 ms·
The schemas are the same. Tables behave the same way logically, and its just performance and physical semantics that are different. We would have recent data i
by manigandham 8y ago
The schemas are the same. Tables behave the same way logically, and its just performance and physical semantics that are different.
We would have recent data in rowstore and move older data into columnstore. You can easily join/union between both for queries. Also some constantly changing data (like budget counters) would always remain in rowstore with many lookups and updates per-second.