Answer
Use partitioning when:
- Tables contain hundreds of millions of rows
- Fast archiving is required
- Hot/cold data separation is needed
- Maintenance takes too long
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ