标签中的table属性用来指明连接表。
创建一个连接表来管理这个关系会非常适合。
Creating a join table to manage this relationship would be the right thing to do.
连接次序指示,强制优化器按照指定次序连接表。
Join order directives that force optimizer to join tables in the designated order.
有时候,如果负载过重,连接会挂起,并且会占用连接表空间。
Sometimes, under load, connections hang around and take up connection table space.
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.
连接表允许将具有一个作者的图书和具有多个作者的图书持久化。
The join table allows you to persist books with a single author as well as books with multiple authors.
这个步骤至少需要3个连接表(3个连接表中包含自连接)。
This step requires a minimum of 3 tables to be joined (where the 3 tables can include self-joins).
当连接表的连接列上没有可用索引时,通常使用该连接方法。
This join method is usually used when no index is available on the join columns for the joining tables.
确实如此,Book和Author之间的关系已经超出了简单连接表的范围。
Indeed, the relationship between Book and Author goes beyond the simple join table.
上图显示了在连接表实现中用相同数量的远程调用(即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.
<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.
您可以连接表1中显示的元素(以及其他操作符)并加以组合使用,从而构建(非常)复杂的正则表达式。
You can string together the primitives in Table 1 (and other operators) and use them in combination to build (very) complex regular expressions.
在这两种情况下,考虑在伪事实表的连接表达式中添加额外的逻辑,这会缩小从维度表返回的连接键值的范围。
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.
当一个或多个连接表上没有索引时,或者当数据库服务器必须从所有连接表中读取大量行时,就使用这种方法。
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.
用户也可以将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.
这条经典欧洲线路在大多欧洲联票的日程表上都有,连接两个中欧的精华目的地。
This classic European journey features on most Inter-Railers itinerary, connecting two of central Europe's essential destinations.
因此需要一个表连接图书和作者,而且这种连接必须是多对多的。
So you need a table to connect a book to an author, and you must allow those connections to be many-to-many.
检验连接并建立示例表和存储过程。
Verify connections and set up sample tables and stored procedures.
相关的输出包括网络连接、路由表、接口统计数据。
Relevant output includes network connections, routing tables, and interface statistics.
它将提示您选择连接并输入新表的名称。
It prompts you to select the connection and to enter the name for the new table.
tcb表存储每个活动TCP连接的控制值。
The TCB table stores the control values for each active TCP connection.
get_user函数连接到包含用户表的数据库并检索给定用户的ID。
The get_user function connects to the database that contains the users table and retrieves the ID for a given user.
您可以连接和结合表1中的基本操作符(以及其他操作符)并进行组合来构建(非常)复杂的regex。
You can concatenate and combine the primitives in Table 1 (and other operators) and use them in combination to build (very) complex regexes.
现在,把每个样式表连接到相应的Web服务操作,见表1。
Now connect each style sheet to its corresponding Web service operation, as shown in Table 1.
如果优化器首先连接两个表,那么连接结果可能十分庞大,并可能使用大量系统资源,如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.
然后,它将连接两个表。
使用了哪些种类谓词来连接引用表?
What kinds of predicates are used to join the referenced tables?
应用推荐