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.
连接开始之前，如果有筛选器，那么数据库服务器首先会应用它们，然后对连接列上每个表中的行进行分类。
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.
连接表允许将具有一个作者的图书和具有多个作者的图书持久化。
This query plan uses hash join for each join between the fact table and a dimension table.
这个查询对每个事实表和维度表之间的连接使用散列连接。
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，并通过散列连接列的值生成一个查找表。
To get the remaining information, join this table with table E2KNVVM007.
为了获得剩余的信息，将此表与表e2KNVVM 007联接在一起。
The performance improvement depends on the selectivity of the filter on the dimension table from which the join keys are pushed down.
性能的提高取决于连接键被下推时所在维度表的过滤选择度。
Creating a join table to manage this relationship would be the right thing to do.
创建一个连接表来管理这个关系会非常适合。
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表，现有的索引表不支持表上的本地和连接谓词，如下所示。
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)。
Indeed, the relationship between Book and Author goes beyond the simple join table.
确实如此，Book和Author之间的关系已经超出了简单连接表的范围。
You will start with the PERSONAL table and use a JOIN operation to get the professional information from the profession table.
您将以PERSONAL数据表开始，并且使用一个JOIN操作从PROFESSION数据表中获得职业信息。
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中的数据。
We've booked a table. We hope you can join us.
我们已经预定了餐馆，希望您能够和我们一起吃饭。
This table also highlights the join of task data with supplemental data using a query table.
该表强调了任务数据和使用查询表的补充数据的连接。
Some evenings I would join the girls in a table-turning seance.
有时晚上我就参加女孩子们转桌子降神的游戏。
应用推荐