Suggest an editImprove this articleRefine the answer for “What is partitioning (partitioning)?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)**Partitioning** is a way to split a large database table into several **smaller, logically related parts**, called **partitions**: it looks like one table, but the data is physically stored in separate segments - by date, value range, category, and so on. **Key point:** the main types are `Range` (by value range), `List` (by specific values), `Hash` (distributed via a hash function for even balance), and `Composite` (combining several methods); partitioning speeds up queries, simplifies maintenance (old data can be archived), reduces write locking, and improves scalability.Shown above the full answer for quick recall.Answer (EN)Image**Partitioning** is a way to split a large database table into several **smaller, logically related parts**, called **partitions**. It looks like one table, but the data is physically stored in separate segments - by date, value range, category, and so on. ### The main types 1. **Range partitioning**, splitting by a value range, e.g. by date: January goes into one partition, February into another. 2. **List partitioning**, splitting by specific values: region "Kyiv" goes into one partition, "Lviv" into another. 3. **Hash partitioning**, data is distributed via a hash function to evenly balance the partitions. 4. **Composite partitioning**, a combination of several methods (e.g. by date and by region). ### Why it's needed - **It speeds up queries**, since lookups only touch the relevant partition. - **It simplifies maintenance**, old data can be archived or deleted without affecting the rest. - **It reduces write locking**. - **It improves scalability**, tables with billions of rows become manageable. In short, partitioning is a way to "slice" a huge table into convenient pieces without losing data integrity.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.