一个分区键应该包括一至三个列。
有包含相同数量的列的分区键。
分区键中不应该包括不必要的列。
Unnecessary columns should not be included in the partitioning key.
假设父表和子表有不同的分区键。
Suppose the parent and child tables have different partitioning keys.
分区键的相应列是分区兼容的。
Have the corresponding columns of the partitioning key be partition compatible.
分区键应该包括最常连接的列。
The partitioning key should include the most frequently joined columns.
通常表分区键是基于时间的列。
Usually the table partitioning key will be a time-based column.
如下的规则和建议适用于分区键定义
The following rules and recommendations apply to the partitioning key definition
为何选择正确的分区键如此重要
在定义分区键时，应考虑以下几点
The following points should also be considered when defining partitioning keys
另外，分区键仍然必须基于关系数据。
In addition, the partitioning key must still be based on relational data.
该定义中使用的列被称为表分区键列。
The columns used in this definition are referred to as the table partitioning key columns.
分区键定义后，就不能更改。
在选择分区键时，应该注意以下几点。
You should bear mind of the following considerations when choosing a partitioning key.
不恰当的分区键可能导致数据分布不均匀。
An inappropriate partitioning key can cause uneven data distribution.
分区键的定义不能修改。
TP只对那些包括表分区键列的查询有利。
TP will only benefit those queries that include the table partitioning key column.
验证现有表上的分区键。
在设计一个网格时，您需要仔细选择分区键。
When designing a grid, you need to choose your partition key carefully.
在这些情况下，建议您基于数据平衡选择分区键。
In such cases, it is recommended that you choose a partitioning key based on even data balancing.
一个分区键由在表创建时定义的一个或多个列组成。
A partitioning key consists of one or more columns defined at table creation.
分区键应该将最常使用的列作为谓词包含在查询中。
The partitioning key should include the columns that are used most often as predicates in queries.
分区键应该由常用于GROUPBY子句的列组成。
The partitioning key should be made up of columns that often participate in a GROUP BY clause.
这个输入参数指定要被用在数据倾斜估算中的新分区键。
This input parameter specifies the new partitioning keys to be used in the estimation of data skews.
应用分区散列算法的代价与分区键的规模成比例。
The cost of applying the partitioning hash algorithm is proportional to the size of the partitioning key.
在这种环境下，应该查看数据模型来决定分区键的最佳选择。
In this kind of environment, you should examine your data model to determine the best choice for partitioning keys.
在一个非分区数据库中，不需要分区键或分区映射。
In a non-partitioned database, no partitioning key or partitioning map is required.
分区键不能多于16 个列，列数越少导致的性能就越好。
The partitioning key cannot be more than 16 columns, but fewer columns result in better performance.
与分区键有关的概念以及创建分区键的规则和建议。
The concepts related to partitioning keys, and the rules and recommendations for creating partitioning keys.
应用推荐