# Partitioned Table

__*Partitioned Table*__

+ Partition types and applicable scenario
  + `Range` 
    + partition pruning, saving I/O overhead
  + `Hash` 
    + Can be used to spread and distribute data evenly among partitions in the case of large-scale writes

------------------------------------------------------------

Advantages of the Range type:     
  - SQL queries must scan a certain amount of data in the table
  - The amount of data being scanned exceeds the threshold, and CBO is more inclined to full table scan than using an index
  - However, due to the size of the data volume, full table scan is not efficient 

Advantages of the hash type:
  - Spread the data and distribute it evenly among the various partitions

In addition, the List and List COLUMNS partition types are experimental and are not recommended for use in production environments at this time. Please visit for the latest information `https://docs.pingcap.com/zh/tidb/v6.0/partitioned-table` .