Question - Explain Database partitioning and its importance.
Answer -
Data partitioning is the process of dividing a logical database into independent units for the betterment of availability, performance, and manageability.
The importance of database partitioning is as follows:
- Enables you to access large parts of a specific partition
- Cheap and slower storage can be used to store data
- Improves query performance