Performance and storage considerations with temporal tables

Introducing temporal tables and adding this functionality to existing tables can significantly increase storage used for data in your system. Since there is no out-of-the-box solution for managing the retention of history tables, if you don't do something, data will remain there forever. This can be painful for storage costs, maintenance, and performance of queries on temporal tables, especially if rows in your current tables are heavily updated.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.118.144.248