SAP HANA TABLE PARTITIONING

Table Partitioning The partitioning feature of the SAP HANA database splits column-store tables horizontally into disjunctive sub-tables or partitions. In this way, large tables can be broken down into smaller, more manageable parts. Partitioning is typically used in multiple-host systems, but it may also be beneficial in single-host systems. Partitioning can be done either in SAP HANA cockpit (refer to SAP HANA Administration with SAP HANA Cockpit) or at the SQL command line. Partitioning is transparent for SQL queries and data manipulation language (DML) statements. There are additional data definition statements (DDL) for partitioning itself: Create table partitions Re-partition tables Merge partitions to one table Add/delete partitions Move partitions to other hosts Perform the delta merge operation on certain partitions @sapbasishana For MORE details - contact: [email protected] #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 @sapbasishana #sap #saptrainingvideos #sapbasishana #saphanaadministration #sapbasisadministration #sapworkprocesses #sap #sapworkprocess #sapbasis #saptraining #SAPECC #TRAINING #PRACTICAL #JOBORIENTED #HANDSON #MIGRATION #S/4HANA #s4hana #IT #FRESHERTRAINING #freshersworld #STUDENT # ​#REALTIMETRAINING #BEGINERS #sapbasis #stms #transport #sapupgrades #sappatching #spam #saint #sum #sap #upgrade #sapupgrades #sappatching