X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2023 MariaDB. All rights reserved.

  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Services
  • Pricing
  • Resources
  • About Us
  • Download
Knowledge Base » MariaDB Server Documentation » MariaDB Administration » Partitioning Tables » Partitioning Types
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
Ask a question here

Partitioning Types

  • Partitioning Types Overview

    A partition type determines how a partitioned table rows are distributed across partitions
  • LIST Partitioning Type

    LIST partitioning is used to assign each partition a list of values
  • RANGE Partitioning Type

    The RANGE partitioning type is used to assign each partition a range of values.
  • HASH Partitioning Type

    Form of partitioning in which the server takes care of the partition in which to place the data.
  • KEY Partitioning Type

    Used to have the server assign the distribution of rows across partitions.
  • RANGE COLUMNS and LIST COLUMNS Partitioning Types

    Used to assign each partition a range or a list of values
  • ← Partitioning Overview
  • ↑ Partitioning Tables ↑
  • Partition Pruning and Selection →
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
  • ↑ Partitioning Tables ↑
  • Partitioning Overview
  • Partitioning Types
  • Partition Pruning and Selection
  • Partition Maintenance
  • Partitioning Limitations
  • Partitions Files
  • Partitions Metadata
Products
  • MariaDB Platform
  • MariaDB SkySQL
  • Pricing
  • Download MariaDB
Services
  • Remote DBA
  • SkyDBA
  • Enterprise Architect
  • Technical Support
  • Migration Practice
  • Consulting
  • Training
Resources
  • Documentation
  • Developers
  • Blog
  • Support
  • OpenWorks
  • Customer Stories
  • Events
  • MariaDB Roadshow
About
  • Contact
  • Leadership
  • Partners
  • Newsroom
  • Investors
  • Careers
  • Trust Center
  • Vulnerability Reporting
Contact

Subscribe to our newsletter!

  • Legal
  • Privacy Policy
  • Cookie Policy

Copyright © 2023 MariaDB. All rights reserved.