Explain The Importance Of Partitioning?

1.	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. Splitting of one table which is large into smaller database entities logically is called database partitioning. Its benefits are:

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.

Splitting of one table which is large into smaller database entities logically is called database partitioning. Its benefits are:

Discussion