连接次序指示，强制优化器按照指定次序连接表。
Join order directives that force optimizer to join tables in the designated order.
flight是连接表，表示其他表之间的复杂关系。
The flight table is the join table, representing the complex relationship among the other tables. Listing 8 shows the fields in the flight table.
当连接表的连接列上没有可用索引时，通常使用该连接方法。
This join method is usually used when no index is available on the join columns for the joining tables.
这个步骤至少需要3个连接表(3个连接表中包含自连接)。
This step requires a minimum of 3 tables to be joined (where the 3 tables can include self-joins).
连接表允许将具有一个作者的图书和具有多个作者的图书持久化。
The join table allows you to persist books with a single author as well as books with multiple authors.
本文简要地综述了基于连接表的手性中心和双键立体化学的描述方法。
The present paper reviews the methods used in connection table for the presentation of stereochemistry, particularly for the chiral carbons and double bonds.
同时文中还介绍了本系统使用的一种简便的紧缩连接表的结构存贮方法。
A simple compact structure storage method used in the system is also presented.
因为该方法在进行表连接之前，必须将所有的连接表分类，所以其成本通常极其高。
Because this method has to sort all joining tables before they join, the costs are usually pretty high.
上图显示了在连接表实现中用相同数量的远程调用（即4 个）来检索整个购物车。
The figure shows that the same number of remote calls, namely four, is used to retrieve the entire shopping cart as in the joined-tables implementation.
您可以连接表1中显示的元素(以及其他操作符)并加以组合使用，从而构建(非常)复杂的正则表达式。
You can string together the primitives in Table 1 (and other operators) and use them in combination to build (very) complex regular expressions.
<many-to-many>标签中的column属性用来指定连接表与目标类的映射表链接的外键。
The <many-to-many> tag's column attribute specifies the foreign key column in the link table that relates the link table to the mapping table for the target class.
当一个或多个连接表上没有索引时，或者当数据库服务器必须从所有连接表中读取大量行时，就使用这种方法。
It is used when there are no indexes on one or more joining tables, or when the database server must read a large number of rows from all joining tables.
在这两种情况下，考虑在伪事实表的连接表达式中添加额外的逻辑，这会缩小从维度表返回的连接键值的范围。
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.
supldata表由连接表中数据和TASK视图中任务数据的列构成，还有申明时安排任务次序所需的列。
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.
OrderItems表是多对多关系中Orders和Products的连接表，这样也不能代表对象模型中的一个实体。
The OrderItems table is a link table in a many-to-many relationship between Orders and Products. As such, it does not represent an entity from the business model.
用户也可以将XML文档和一个xslt样式表存储在不同的表中，而且可以通过连接表将单个xslt样式表应用到多个xml值。
Users can also store the XML documents and an XSLT stylesheet in separate tables and can apply a single XSLT stylesheet on multiple XML values by joining the tables.
在数据库中，用三个表表示m： m关系：前两个表您已经知道了(Book和Author)，第三个是一个连接表(BookAuthor)。
In a database, three tables represent m: m relationships: the two tables you'd expect (Book and Author), and a third join table (BookAuthor).
如果该查询包含了连接，那么优化器就必须确定连接计划(hash、sortmerge或nestedloop)，以及评估或连接表的次序。
If the query includes a join, the optimizer must determine the join plan (hash, sort merge, or nested loop), and the order in which tables are evaluated or joined.
GORM向BookAuthor 连接表添加 book_id和 author_id，而不是向Book或Author 表添加一个外键。
Rather than adding a foreign key to either the Book or Author table, GORM adds book_id and author_id to the BookAuthor join table.
这里您看到的是一个连接，内表在其中执行数据库修改。
What you see here is a join in which the inner performs database modifications.
检验连接并建立示例表和存储过程。
Verify connections and set up sample tables and stored procedures.
相关的输出包括网络连接、路由表、接口统计数据。
Relevant output includes network connections, routing tables, and interface statistics.
如果优化器首先连接两个表，那么连接结果可能十分庞大，并可能使用大量系统资源，如CPU和内存。
If the optimizer joins two tables first, the join results could be huge and may use a large amount of system resources such as CPU and memory.
它将提示您选择连接并输入新表的名称。
It prompts you to select the connection and to enter the name for the new table.
需要按分区键进行连接的表应该有相同数量的分区，并且应该在相同的值上断开。
Tables that will be joined on the partitioning key should have the same number of partitions and should break on the same values.
编写使用这些比较高级的表连接的SQL查询将在后续文章中介绍。
Writing SQL queries that use these more advanced table joins will be addressed in future articles.
关系数据库为sql语句提供了从一个以上的表中访问信息的能力，这是通过连接多个表来完成的。
Relational databases provide the capability for the SQL statements to access information from more than one table through a joining of multiple tables.
这一节将重点介绍如何从单表中选择数据；本文中的最后一节将介绍表连接和如何从多个表中进行选择。
This section focuses on selecting data from a single table; the last section in this article covers table joins and selecting data from multiple tables.
根据各种标准，如本地谓词或连接谓词，以及表引用来定制谓词的格式化顺序。
Customize the formatting ordering of the predicates according to various criteria such as local predicates or join predicates, and table references.
根据各种标准，如本地谓词或连接谓词，以及表引用来定制谓词的格式化顺序。
Customize the formatting ordering of the predicates according to various criteria such as local predicates or join predicates, and table references.
应用推荐