Partitioning revisited
On This Lesson 4 topics
This lesson is planned. The outline below lists the topics it will cover. The full lesson has not been published yet.
In this lesson
use partitioning inside one database to manage large tables.
Planned topics
- Declarative partitioning splits a table by range, list, or hash within one server (details in earlier modules; verify version features).
- Benefits: pruning, cheaper retention (drop a partition), smaller indexes.
- It does not add write capacity beyond one server.
- Queries must include the partition key to prune.
Draft outline details
Demonstration
orders partitioned monthly by created_at; dropping a partition removes old data fast.
Check your understanding
Does partitioning in one server increase write capacity beyond that server?
Show answer
No.
Practice
Apply this lesson with the module's lab, exercises and quiz.
Marking a lesson complete is optional and you can undo it any time. Your progress stays in this browser.