In this example, each row of the outer table shows information about a different user.
在这个范例中,外层表格的每一行都显示了关于不同用户的信息。
The outer table can be accessed by an index scan or by a table scan, depending on the table.
通过索引扫描还是表扫描来访问外部表则取决于该表。
Now the inner table shows only the links that have the work item in the outer table as a target.
现在内部表格只是显示了外层表格中的工作项作为目标。
Because of how nested loop joins work, the second leg (there are four nodes) is executed per outer table record.
因为嵌套循环联接的工作方式,所以每隔一个外部表记录执行第二步(共4个节点)。
Under Sub-Category, click table, which refers to the outer table of users, not the inner table of work items.
在Sub - Category之下,点击Table,它会引用用户外层表格,而不是工作项的内层表格。
One record of the inner table will match each qualifying record from the outer table (inner Input Cardinality value is 1).
一条内部表的记录将与来自外部表的每条合格的记录相匹配(内部输入基数值是1)。
Select the inner table of links, and bind its TARGET_ITEMID column to the WI_ITEMID column of the outer table (Figure 15).
选择联系的内部表格,并将其TARGET _ itemid列于外层表格(图15)的wi_itemid列联系起来。
You can do this by passing a parameter (in this case, the owner's user ID) from the outer table row to the inner table.
您可以通过从外层表格向内层表格发送一个参数(在本例中,是所有者的用户ID),来实现这项任务。
For every row found in the outer table, the database server searches for its corresponding row in the second (or inner) table.
对于在外部表中找到的每一行,数据库服务器将在第二个(或内部)表中搜索其相应的行。
This nested table of work items is filtered to show only the work items for the user in the current row of the outer table.
这些工作项的固定表格会得到筛选,只显示外层表格当前行的工作项。
The nested table of work items is placed inside the outer table, so that the nested table repeats in each row of the outer table.
工作项的固定表格位于外层表格的里面,这样固定的表格会重复外层表格中的每一行。
If a cancellous graft with one cortex is desired elevate only the muscles from either the inner or outer table of the ilium.
如仅需带一侧皮质骨板的松质骨植骨块,仅需剥离外侧或内侧髂骨板表面的肌肉。
Objective to study the autogenous outer table of mandibular as bone graft in management of severe trauma saddle deformity of nose.
目的探讨自体下颌骨外板作为鼻支架在外伤后严重鞍鼻畸形矫正中的应用。
For this report to make sense, you must limit the inner table to show only the work items that are owned by the user in the outer table row.
为了实现这一份报表,您必须将inner表格限制为只显示outer表格行中用户所拥有的工作项。
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 表。
Results Of 18 cases, the lesion was located in skull in 6, presenting as round or oval osteolytic destruction with soft tissue mass at inner and outer table.
结果颅骨6例,表现为圆形、类圆形骨质破坏伴颅板内外软组织肿块;
IT then reads from the outer table BAD_CREDIT using the SHIP operator, hashing the join column values, and checking in the lookup table generated for the inner table.
然后,它使用SHIP操作符读外表BAD_CREDIT,散列连接列的值,并检查为内表生成的查找表。
In this way, the inner table is an element of the outer table's cell, and the onRender events of the table, detail row and cell are firing before the inner table does.
通过这种方式,内部表格就是外部表格单元的一个元素,以及表格的onRender事件,具体行和单元会在内部表格操作之前引发。
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.
在数据库服务器使用所有表筛选器之后,从外部表检索出的行数将很少,而内部表具有一个可用于执行连接的索引。
You'll learn more about these expressions later. For now, enter an expression that refers to the user ID in the current row of the outer table, as described in the following steps.
稍后您将会学到更多关于这些表达式的信息。
The higher the cardinality, the more probes into the inner table, one per qualifying (outer) record.
基数越高,进入内部表、每一条合格的(外部)记录的探测就越多。
Typically, the optimizer chooses merge scan join when the cardinality of the outer input is not obviously small and there is no efficient access method for the inner table.
通常情况下,在外部输入的基数显然不小且对于内部表没有一种有效的访问方法时,优化器会选择合并扫描联接。
This example USES two for loops. The outer for loop takes care of each row in The Times table, and the nested for loop takes care of the columns within each row.
本例使用两个for循环,外面的for循环关注乘法表中的每一行,嵌套的for循环关注每行内的列。
The trick is getting the table names array from the outer block into the inner block without explicitly passing it in somehow (which would have made the DSL ugly).
此处的技巧是:将表名数组从外部的block隐式地传递到内部的block中。用显式方式传递会让DSL看起来很丑陋。
The merge statement first does a join (outer join or inner join, depending on the merge statement) between source and target table rows.
merge语句首先进行(外部联接或者内部联接,取决于merge语句)源与目标表行之间的联接。
If there is an index on the join column, the costs will be significantly less; otherwise the database server must perform table scans for all tables, both outer and inner tables.
如果连接列上有一个索引,那么其成本会相当低;否则,数据库服务器就必须对所有表(外部和内部表)执行表扫描。
The table is formatted with two layers of brackets; the outer brackets encloses the entire table for the step; the inner brackets designate a row in the table.
表的格式为两层中括号。外层的中括号包含了步骤的整个表,内层的中括号是表中的一行。
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 last photo shows the fixture Tom used in the rotary table to machine the outer shape of the rocker arms with their rounded ends.
最后一张照片显示夹具汤姆用于旋转机械表的外部形状摇杆武器与他们四舍五入目的。
The last photo shows the fixture Tom used in the rotary table to machine the outer shape of the rocker arms with their rounded ends.
最后一张照片显示夹具汤姆用于旋转机械表的外部形状摇杆武器与他们四舍五入目的。
应用推荐