Explain database partitioning and its importance?

All Questions › Category: Database › Explain database partitioning and its importance?
0 Vote Up Vote Down
chetan shidling asked 4 years ago

I need short information.

1 Answers
0 Vote Up Vote Down
chetan shidling answered 4 years ago

Data partitioning is the process of dividing a logical database into independent units for the betterment of availability, performance, and manageability.
 

  1. Enables you to access large parts of a specific partition.
  2. Cheap and slower storage can be used to store data.
  3. Improves query performance.