有包含相同数量的列的分区键。
分区键中不应该包括不必要的列。
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.
如下的规则和建议适用于分区键定义
The following rules and recommendations apply to the partitioning key definition
在定义分区键时，应考虑以下几点
The following points should also be considered when defining partitioning keys
该定义中使用的列被称为表分区键列。
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.
验证现有表上的分区键。
在这些情况下，建议您基于数据平衡选择分区键。
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.
对于TP，设计决定包括选择用作表分区键的列和分区的数量。
For TP, design decisions include selecting the column to use as the table partitioning key and number of partitions.
分区键不应该包括没有将数据均匀分布或具有少数不同值的列。
The partitioning key should not include a column with unevenly distributed data or with a small number of distinct values.
基于数据模型，选择那些有利于频繁合并且基于主键的分区键。
Based on your data model, you should select partitioning keys that favor frequent joins and that are based on a primary key.
表的主键和所有惟一索引都必须是相关分区键的超集。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
本文提供了如何根据您自己的需要选择最佳分区键的指导和工具。
This article provided guidance and tooling for choosing the best partitioning keys based on your needs.
整型分区键要比字符键高效，而字符键又比小数键高效。
An integer partitioning key is more efficient than a character key, which is more efficient than a decimal key.
对于被合并的表的分区键内的每列，必须存在一个同等连接的谓语。
For each column in the partitioning key of the joined tables, an equijoin predicate must exist.
您需要根据应用程序的业务流程，确定用正确的分区键划分哪些表。
Based on your application's business processes, you need to identify which tables to partition with the correct partitioning key.
应用推荐