There are several reasons you might want to use dynamic partitioning in HANA platform / HANA Cloud.
Using partitioning allows the user to control the number of rows in a partition as well as they way the data is stored. If you want your data to stay on disk until it is used in memory, you can control this. This is call NSE or Native Storage Extension. Using this in a dynamic manner you get:
HOT and WARM data separation/sortingEasy to use partitioning in HDI and CAP applications/tablesReduces maintenance for partitioning administration Prevent overrunning tables by the 2 billion row limit
There are several reasons you might want to use dynamic partitioning in HANA platform / HANA Cloud.Using partitioning allows the user to control the number of rows in a partition as well as they way the data is stored. If you want your data to stay on disk until it is used in memory, you can control this. This is call NSE or Native Storage Extension. Using this in a dynamic manner you get:HOT and WARM data separation/sortingEasy to use partitioning in HDI and CAP applications/tablesReduces maintenance for partitioning administration Prevent overrunning tables by the 2 billion row limit Read More Technology Blogs by SAP articles
#SAP
#SAPTechnologyblog