This gives us 23 tables and a 24-table join to retrieve a DICOMData object.
这会产生23个表，而且检索一个DICOMData对象要连接 24 个表。
But in simple terms, a table join creates a composite table from two other tables.
但是用简单的术语来说，一个表格联系会从两个不同的表格创建一个组合表格。
Here you have a three-table join involving a UNION, and from the db2exfmt output pertaining to the query, you have.
假设有一个涉及UNION的三表连接和来自查询的db 2 exfmt输出。
As part of the transformation, the optimizer also determines the correct table join order, rewrites expressions, and eliminates any redundancy from the SQL.
作为转换的一部分，优化器还决定正确的表联接顺序，重写表达式，并从SQL中消除任何冗余。
Specify the condition for the table Join operator by connecting the tables using the unique term number, which is SKILL_ID in the result set of the text analysis and TERM_ID in the taxonomy table.
通过使用唯一的术语编号将表连接起来，为Table Join操作符指定条件，术语编号为文本分析结果集中的SKILL_ID，和位于分类表中的TERM_ID。
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.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
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.
性能的提高取决于连接键被下推时所在维度表的过滤选择度。
You would probably need to set up a many-to-many relationship with a join table, requiring several joins to determine the actors for a particular movie.
您可能需要使用一个联接表设置一个多对多关系，这需要几个联接来确定某个电影的演员。
This provides the table a default order and a fast way to join the table against other tables.
这为表提供一个默认顺序和快速方式来联接其他表。
It's a right-deep query plan such that for each hash join, the build table is a small dimension table.
每个散列连接都是右深查询，构建的表是一个小的维度表。
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是连接表，表示其他表之间的复杂关系。
应用推荐