This is the process of partitioning tables, indexes into smaller pieces in order to manage and access the data at a finer level.
This reduces the cost of storing a large amount of data as well as enhances the performance and manageability.
Database partitioning also gives us the following advantages:
- Improves query performance and manageability.
- Simplifies common administration tasks.
- Acts as a key tool for building systems with extremely high availability requirements.
- Allows accessing a large part of a single partition.