Database - partitioning an important
part of database optimization - Jan 07, 2010, 13:55 pm by Vidya
Sagar
Explain how is partitioning an important part of database optimization.
Database partitioning is the process of splitting one large
table of a database logically into smaller physical entities. Partition
benefits in
- Improving query performance dramatically in situations when
most of the heavily accessed rows of the table are in a single partition.
- To access large percentage of a single partition the queries or updates are
accessed by queries, the performance can be improved by taking advantage of
scanning the partition sequentially.
- Data that is seldom used could be migrated for cheaper and slower storage
media.
|