Question - Explain the importance of partitioning.
Answer -
Splitting of one table which is large into smaller database entities logically is called database partitioning. Its benefits are:
- To improve query performance in situations dramatically when mostly rows which are heavily accessed are in one partition.
- Accessing large parts of a single partition
- Slower and cheaper storage media can be used for data which is seldom used.