IT lexicon › Database › Partitioning

Partitioning

Database På svenska → Updated: 2026-05-23

Split a large table into smaller physical pieces based on some criterion — date, customer ID, region.

Range partitioning: one partition per month. Hash partitioning: even distribution. Faster queries (the database only reads relevant partitions). Easier to archive/delete old data. Different from sharding (separate nodes).

← Back to the lexicon