Database Essentials - Partitioning Tables and Indexes - Overview of Partitioning

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.

Watch the video tutorial here