Partitioning an important part of database optimization

Explain how partitioning is an important part of database optimization?

- Partitioning distributes database tables over different database which may reside on a different server.

- Vertical portioning helps to fit more rows on a database page to improve data access performance.

- Partitioning helps to do multiple tasks simultaneously.

- It increases performance.

- It helps to manage data.

- Database partitioning is the process of splitting one large table of a database logically into smaller physical entities.

Following are the benefits of Partitioning:

1. Improving query performance dramatically in situations when most of the heavily accessed rows of the table are in a single partition.

2. To access large percentage of a single partition of the queries or updates are accessed by the queries, the performance can be improved by taking advantage of scanning the partition sequentially.

3. Data that is seldom used could be migrated for cheaper and slower storage media.