Range, hash, and list partitioning — split large tables for better query performance and manageability.
Five passes over the same idea, each from a different angle. Do them in order, or jump to whichever you need.
Table partitioning divides large tables into smaller, manageable pieces. Range partitioning (by date), hash partitioning (even distribution), and list partitioning (by category) serve different use cases. Partition pruning speeds queries. Related to sharding (cross-node) but works within a single database instance.
Where this topic shows up outside its home domain:
