Explain database partitioning and its importance?


Warning: Trying to access array offset on false in /home3/indiakep/public_html/wp-content/plugins/dw-question-answer/inc/Template.php on line 8
All Questions › Category: Database › Explain database partitioning and its importance?
0 Vote Up Vote Down
chetan shidling asked 5 years ago

I need short information.

1 Answers
0 Vote Up Vote Down
chetan shidling answered 5 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.