January 3, 2013

What is partitions of tables in sql

Partition is used to split the table i,e Partition this is recommended when your table is so large.Types of partition are

range part
hash
list
composite range hash partition
composite range list partitions

Partition can be done at create table statement or can alter table.