In this section, we will describe an example to show how to use a space curve value as the partition key to achieve partitioning that is similar to X and Y-based partitioning. This approach has some advantages and disadvantages when compared to multi-key range-based partitioning. We can use a single partition key instead of the multi-column partition key. If a new partition is to be added by splitting any of the existing partitions, multi-key partitions are harder to manage if only one partition needs to be split based on the first value of the partition key. On the other hand, the multi-key partitioning provides an easy-to-use method for coming up with initial partitions that have the same number of rows in each partition.
For this example, we will use the land_parcels
table to show the concept of spatial-based partitioning for tables with non-point geometry data. Before we create the partitioned table, we will first revisit the space curve concepts. We learned...