Categories
DBA

Partitioning

Partitioning is all about dividing of datas to make it faster access either by reading or writing into the table. i.e improving query execution time. Partitioning can be done at Table and Index level. These are the new features in SQL server 2005 and these are supported only at Enterprise and Developer edition. The data in partitioned tables and indexes is horizontally divided into units that can be spread across more than one filegroup in a database. Partitioning can make large tables and indexes more manageable and scalable. Up to 1000 partitions per object (table or index) are supported. Lets go into detail about the topic.

Categories
DBA

How Partitioned table works

Partitioning is nothing but dividing of datas according to the requirement to improve query performance. Consider you are having a table with large number of datas. Here in table partitioning we are going to implement horizontal partition, where the rows in the table will be based on one the column in table.