Using DYNAMIC partitioning with HANA Platform / HANA Cloud and leverage NSE (disk) storage

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

You May Also Like

More From Author