Horizontal - Partition in SQL Server - Part 3
Click here to Subscribe to IT PORT Channel : / @itport28
Horizontal partitioning divides a large table into smaller more manageable parts without having to create separate tables for each part. Data in a partitioned table is physically stored in groups of rows called partitions and each partition can be accessed and maintained separately. Partitioning is not visible to end users, a partitioned table behaves like one logical table when queried
Partitioned Column : Data in a partitioned table is partitioned based on a single column, the partition column, often called the partition key. Only one column can be used as the partition column, but it is possible to use a computed column
Partition Function: It defines how to partition data based on the partition column. The partition function does not explicitly define the partitions and which rows are placed in each partition
Partition Scheme : It maps the logical partitions to physical file groups. It is possible to map each partition to its own file group or all partitions to one file group