The article should only have one parameterized filter or join filter.
项目应只有一个参数化筛选器或联接筛选器。
Each join reduces the size of the fact table by one-tenth due to selectivity of the table filter on each dimension table.
由于每个维度表过滤的选择度，每次连接都会减少事实表大小的十分之一。
This is the same join predicate applied at FILTER(10).
和应用于FILTER(10) 的连接断言相同。
Often the join order of a query will greatly determine the query execution performance, since it is more efficient to filter rows as early as possible.
通常，查询的连接顺序很大程度上决定了查询的执行性能，因为越早地过滤行，效率越高。
The performance improvement depends on the selectivity of the filter on the dimension table from which the join keys are pushed down.
性能的提高取决于连接键被下推时所在维度表的过滤选择度。
When hash tables are built, join keys are pushed down and used to filter the rows of the fact table, and performance improves dramatically.
构建散列表时，连接键被下推用于过滤事实表的行，性能也显著提高。
In a star join plan, the database server pushes down keys from a dimension table to filter the fact table at the same time as it builds the hash table on the dimension table.
星型连接计划中，数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
Use UPDATE STATISTICS HIGH if queries have a multi-column indexed defined on join columns or filter columns.
如果查询中有属于多列索引的连接列或过滤列，则使用UPDATESTATISTICSHIGH。
The time_id join keys that meet the filter requirements on the Time dimension table are hashed to create a bit vector that filters rows of the Orders table from the skip scan above.
Time维度表中满足过滤条件的 time_id连接键被散列以创建一个位向量，用于过滤以上跳跃式扫描的Orders 表行。
Use UPDATE STATISTICS MEDIUM DISTRIBUTIONS ONLY if queries have non-indexed join columns or filter columns.
仅当查询中有非索引连接列或过滤列时，才使用UPDATESTATISTICSMEDIUMDISTRIBUTIONS。
The location_id join keys that meet the filter requirements on the Location dimension table are pushed down to the index on the Orders table.
Location维度表中满足过滤条件的 location_id连接键被下推至Orders 表的索引。
Exclude rows by defining a filter on a table. You can extend the filter by defining a JOIN from a filtered table to another table.
通过在表上定义筛选可以排除某些行，还可以通过定义从筛选表到其它表的联接来扩展筛选。
We could then apply a tree manipulation to move the Filter node underneath the Join node toward the related Table node.
随后，我们可以应用一项树操作，将Join节点下方的Filter节点朝着相关Table节点的方向移动。
The join condition is the on clause filter specified in the merge statement.
在merge语句的on子句中指定了联接条件。
The join condition is the on clause filter specified in the merge statement.
在merge语句的on子句中指定了联接条件。
应用推荐