This is the second part of the three part article series on partitioning relational data.
In the first part of this three-part article series on partitioning relation data, I gave an introduction to partition relational data along with the reasons why someone might want to partition relational data. Then I discussed how to partition tables and how to match indexes to match partitioned tables. In the end I discussed the rules that must be taken into account when partitioning tables and indexes.
Checkout the second part of partitioning relational data article series here. In this part I discussed how you can convert existing table to partition table, add, modify, remove or switch partitions, and how you can view data in a specific partition.
This article is published on SSWUG.org.