Before the join begins, the database server first applies filters if there are any, and then sorts the rows for each table on the join column.
连接开始之前，如果有筛选器，那么数据库服务器首先会应用它们，然后对连接列上每个表中的行进行分类。
It selects a hash join with PART as the inner table which runs in 299 seconds.
它选择一个散列连接，以PART作为内部表，这个计划只需运行299秒。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
This is a lot faster than a nested loop join of two table scans without any index usage.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
Customize the formatting ordering of the predicates according to various criteria such as local predicates or join predicates, and table references.
根据各种标准，如本地谓词或连接谓词，以及表引用来定制谓词的格式化顺序。
The join table allows you to persist books with a single author as well as books with multiple authors.
连接表允许将具有一个作者的图书和具有多个作者的图书持久化。
Finally, Table 5 shows the join between a book and its author, which in a lot of ways comprises the most important data you've seen yet.
表5显示了图书和作者之间的连接，从很多方面来说这是迄今您见过的最重要的数据。
As a database developer, you usually join the customer table to the contact table and treat the customer as the main table.
作为数据库开发人员，您通常将客户表与联系方式表连接，并将客户表视作主表。
This query plan uses hash join for each join between the fact table and a dimension table.
这个查询对每个事实表和维度表之间的连接使用散列连接。
In either case, consider adding additional logic in the join expressions to the fake fact table that will reduce the range of join key values that can be returned from the dimension tables.
在这两种情况下，考虑在伪事实表的连接表达式中添加额外的逻辑，这会缩小从维度表返回的连接键值的范围。
If specified, it can only take the value 'TRUE' to indicate that the given table must be the first table accessed in a join query.
如果指定了的话，它将只接受“TRUE”值，表示给定表必须是连接查询中进行访问的第一个表。
In the query access plan shown in Listing 9, notice a join between the table EMPLOYEE and a table function, GENROW.
在清单9所示的查询访问计划中，要注意表employee和一个表函数GENROW间的一个连接。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
As part of the transformation, the optimizer also determines the correct table join order, rewrites expressions, and eliminates any redundancy from the SQL.
作为转换的一部分，优化器还决定正确的表联接顺序，重写表达式，并从SQL中消除任何冗余。
The join is performed by scanning the inner table of the hash join, CUSTOMERS, and generating a lookup table by hashing the join column values.
该连接的执行过程包括扫描散列连接中的内表CUSTOMERS，并通过散列连接列的值生成一个查找表。
The performance improvement depends on the selectivity of the filter on the dimension table from which the join keys are pushed down.
性能的提高取决于连接键被下推时所在维度表的过滤选择度。
But in simple terms, a table join creates a composite table from two other tables.
但是用简单的术语来说，一个表格联系会从两个不同的表格创建一个组合表格。
This provides the table a default order and a fast way to join the table against other tables.
这为表提供一个默认顺序和快速方式来联接其他表。
The larger the probe table is in a hash join, the slower the join is.
散列连接中的探测表越大，连接就越慢。
For table CUST_ORDER_HEADER, both of the existing indexes do not support the local and join predicates on the table, as shown below.
对于cust_order_header表，现有的索引表不支持表上的本地和连接谓词，如下所示。
The SUPLDATA table consists of columns needed to join the data in the table with the task data in the task view, as well as columns needed to order the tasks when they are claimed.
supldata表由连接表中数据和TASK视图中任务数据的列构成，还有申明时安排任务次序所需的列。
In a database, three tables represent m: m relationships: the two tables you'd expect (Book and Author), and a third join table (BookAuthor).
在数据库中，用三个表表示m： m关系：前两个表您已经知道了(Book和Author)，第三个是一个连接表(BookAuthor)。
Join the resulting table with the taxonomy table to allow higher value analysis by following these steps.
通过以下步骤将生成的表与分类表连接起来，从而实现更高的价值分析。
Query 2 applies the join predicate to the authors table.
查询2对authors表应用连接谓词。
The flight table is the join table, representing the complex relationship among the other tables. Listing 8 shows the fields in the flight table.
flight是连接表，表示其他表之间的复杂关系。
That is, the inner table of the join operation will be scanned eight times, once for each of the eight qualifying records from the outer input.
也就是说，联接操作的内部表将被扫描8次，来自外部输入的 8 个合格的记录每个都将被扫描一次。
The guideline specifies that table SECURITY should be the outer table in the join and the XML index SEC_INDUSTRY should be used to access the SECURITY table.
该准则指定应当将表SECURITY 作为连接中的外表，而XML索引 SEC_INDUSTRY 应当被用于访问 SECURITY 表。
Columns in the join clauses in fact table of star schema database.
星型数据库的事实表中join子句中的列。
The guideline also specifies that the table CUSTACC should be the inner table of the join and the XML index ACC_CURRENCY should be used to access the CUSTACC table.
准则还指定应当将表CUSTACC作为连接的内表，而xml索引acc_currency应当用于访问custacc表。
Testing the subject and subscription association means we must access both the data in the SUBJECTS and the SUBSCRIPTIONS table, as well as the join table SUBJECTS_SUBCRIPTIONS.
要想测试主题和订阅的关联，就必须访问SUBJECTS和subscriptions表以及联结表subjects_subcriptions中的数据。
应用推荐