Рет қаралды 1,093
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: KPONLINETRAININGS@GMAIL.COM
#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