Friday, 9 September 2011

Partition

What is partition? How many types of partition.
Spliting a table or index into smaller & more manageable pieces is called partitions.
Each partition of a table or index must have the same logical attributes,
such as column names, datatypes, and constraints.

There are several partitioning methods viz:
a. List Partition
b. Range Partition
c. Hash Partition
d. Composite Partition