Partitioning Relational Data – (Part – 2)

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.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s