Most of the modern database technologies support a wide variety of partitioning strategies. However, some of the most commonly used ones include:
- List Partitioning
- Range Partitioning
- Hash Partitioning
Among these, List and Range Partitioning are more widely used compared to Hash Partitioning. Additionally, we can also mix and match these strategies to have multi-level partitioning, known as sub-partitioning.
When it comes to partitioning a table, we can do so with or without a primary key. If the partition column is a prime attribute (one of the primary key columns), we can partition a table with a primary key.
Indexes can also be added to the partitioned table. When creating an index on the main table, it is a global index. However, creating an index on each partition results in a partitioned index.