对于被合并的表的分区键内的每列,必须存在一个同等连接的谓语。
For each column in the partitioning key of the joined tables, an equijoin predicate must exist.
如果基于查询工作负载选择一个分区键,那么此分区键通常应该包含一个合并列或常被用于很多查询的一组列。
If you choose a partitioning key based on your query workload, the partitioning key should typically consist of either a joined column or a set of columns that is frequently used in many queries.
基于数据模型,选择那些有利于频繁合并且基于主键的分区键。
Based on your data model, you should select partitioning keys that favor frequent joins and that are based on a primary key.
应用推荐