Partitioning (Single-Node)
Back: Relational Databases
Splitting a large table into smaller physical pieces while presenting one logical table. Partitioning improves query performance on large tables by enabling partition pruning and simplifies data lifecycle management.
Concepts
- Table Partitioning
- Range Partitioning
- List Partitioning
- Hash Partitioning
- Composite Partitioning
- Partition Pruning
- Postgres Partitioning
- MySQL Partitioning
- When to Partition