Questions about TiDB Partitioning

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB分区的疑惑

| username: ihuiyun

May I ask if TiDB requires that each unique key of a partitioned table must include all the columns used in the partition expression, then will the execution of SQL with partition fields be faster than a non-partitioned table with the same index? Can you explain the specific execution logic? :hushed:

2
| username: xiaohetao | Original post link

I think one of the reasons for partitioning is that large tables can be queried faster. Partitioned tables of the same scale are definitely faster to query than regular tables.