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显示了图书和作者之间的连接，从很多方面来说这是迄今您见过的最重要的数据。
Table and use an AS clause to name these columns for the display with the ij tool. Because the query joins these two tables (by using an implicit inner join), you can select columns from both tables.
因为查询(通过使用隐式内连接)将两个表连接，您可以从两个表中选择列。
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是连接表，表示其他表之间的复杂关系。
The join table allows you to persist books with a single author as well as books with multiple authors.
连接表允许将具有一个作者的图书和具有多个作者的图书持久化。
This is a lot faster than a nested loop join of two table scans without any index usage.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
The performance improvement depends on the selectivity of the filter on the dimension table from which the join keys are pushed down.
性能的提高取决于连接键被下推时所在维度表的过滤选择度。
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)。
Customize the formatting ordering of the predicates according to various criteria such as local predicates or join predicates, and table references.
根据各种标准，如本地谓词或连接谓词，以及表引用来定制谓词的格式化顺序。
Query 2 applies the join predicate to the authors table.
查询2对authors表应用连接谓词。
It selects a hash join with PART as the inner table which runs in 299 seconds.
它选择一个散列连接，以PART作为内部表，这个计划只需运行299秒。
The fact table in the dimensional model has a single join with all the other dimension tables.
维度模型中的事实表与其他所有维度表之间存在单一连接。
You can define guidelines that influence only a few attributes of an execution plan, such as index specification for a certain table in the query or join order for a pair of tables.
可以定义那些只影响执行计划的某些属性的准则，比如查询中的某个表的索引说明，或者一对表的连接顺序。
Instead, use a virtual table with a WHERE clause, or define the join as a view in the data source, and execute the rule on this view.
相反，可使用具有where子句的虚拟表，或者将连接作为数据源的视图进行定义，并在这一视图中执行规则。
Note: in Version 4.0 of Personalization, you can select more than one table on the first screen and join data from multiple tables on this screen.
注：在Personalization的版本4.0中，您可以在第一屏中选择多个表，然后在这一屏中连接多个表的数据。
The second major function performed by a WHERE clause is to join multiple tables together into a single table that can be queried more easily.
WHERE 子句执行的第二个主要功能是将多个表连接到单个表中，从而更易于查询。
Figure 4 shows a rule with bindings that involve columns coming from more than one table, which causes the sampling to be done after the join operation.
图4展示了具有绑定的规则，它涉及来自多个表的列，这导致了在连接操作之后进行抽样。
When hash tables are built, join keys are pushed down and used to filter the rows of the fact table, and performance improves dramatically.
构建散列表时，连接键被下推用于过滤事实表的行，性能也显著提高。
To ensure the database is normalized (see Note 1), a new table SUBJECTS_SUBSCRIPTIONS will be created to join the SUBJECTS and SUBSCRIPTIONS tables.
为了确保数据库是规范化的(参见注1)，创建一个新的表subjects_subscriptions来连接SUBJECTS和subscriptions表。
The larger the probe table is in a hash join, the slower the join is.
散列连接中的探测表越大，连接就越慢。
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间的一个连接。
The optimizer will then join that temp table to the fact table using the compound index to quickly locate the rows that satisfy the criteria on the dimension tables.
优化器然后使用复合索引将临时表连接到事实表，来快速定位在维度表中满足条件的行。
As a database developer, you usually join the customer table to the contact table and treat the customer as the main table.
作为数据库开发人员，您通常将客户表与联系方式表连接，并将客户表视作主表。
The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.
在数据库服务器使用所有表筛选器之后，从外部表检索出的行数将很少，而内部表具有一个可用于执行连接的索引。
In the current simple scheme, the process is simple; Listing 5 performs an implicit inner join of the bigdog.products table and the bigdog.vendors.
在当前的简单模式中，过程十分简单；清单5执行bigdog . products表和bigdog .vendors表之间的隐式内连接。
After the first table has been scanned and placed in a hash table, the second table is scanned and each row in the table is looked up in the hash table to see if a join can be made.
在扫描完第一个表并将它放在哈希表中之后，就扫描第二个表，并在哈希表中查找该表中的每一行，看是否可以进行连接。
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 表的索引。
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，并通过散列连接列的值生成一个查找表。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
应用推荐