SAP HANA Admin - Table Partition

Using Partitioning, you can split column store tables into smaller tables in a multiple host system. You can even divide tables into smaller more manageable parts using partitioning. Partitioning can be done using DML SQL statements.
When a table is partitioned it contains different set of rows for each part and Partitioning can be done based on different algorithms - Hash Partitioning, Single Level or multilevel Partitioning.
Following are the advantages of using Table Partitioning −
Partitioning Pruning
You can determine if a query can be analyzed in a particular partition. Using this method, you can reduce the load on the system and hence improve the response time.
Example − When you partition a table based on the year, a query is executed to analyze the data for a particular year. You can use specific partition and hence query performance is improved.
Load Balancing
You can divide individual partitions on multiple hosts and hence a query is not processed by a single server, results in better load balancing on all the servers hosting table partitions.
Size Limitation
In a column store table, maximum number of rows that can be entered is around 2 billion. You can overcome this by distributing the rows of a column table on multiple partitions and hence the size limit is increased to 2 billion for each partition.
Improved Delta Merge Operation
During delta merge, if data is only modified for some partitions, you need to merge less partitions in delta merge.
Parallel Processing of Queries
Using partitions, you can run multiple queries in parallel and hence improve the response time.
Let us now discuss the types of partionining.
Single Level Partitioning
There are different types of single level partitioning available in SAP HANA system −
Hash Partitioning
Round Robin Partitioning
Range Partitioning
In Hash partitioning, rows are distributed equally to perform load balancing. You don’t require the detailed information about table content in this Partitioning type.
As compared to Hash Partitioning, in Round Robin Partitioning rows are equally distributed to each partition and new rows are equally assigned to each partition.
‪@sapbasishana‬
For MORE details - contact: [e-mail]
#SAP #BASIS #SAPHANA #SAPECC #TRAINING #PRACTICAL #JOBORIENTED #HANDSON
#MIGRATION #S/4HANA #s4hana #IT #freshersjob #FRESHERTRAINING #freshersworld #STUDENT # ​#REALTIMETRAINING #BEGINERS #saphanatraining #saptraining #sapbtp #sapbasis #saptraining #sapbasishana