The plan shows a table scan over the aggregate_sales MQT. Moreover, the details of the operator table scan shows the following details.
该计划展示了aggregate_salesMQT上的一个表扫描。
For our purposes, it suffices to understand that asynchrony is introduced into a federated query plan by the optimizer's judicious placement of the TQ (Table Queue) operator.
就我们此处的目的而言，只要理解异步是通过优化器明智地放置TQ(表队列)操作符而引入到联邦查询计划之中的就足够了。
A table target operator for "RETAIL_RULES" should now be shown in the mining flow.
针对“RETAIL_RULES”的一个表目标操作符现在应被显示在挖掘流中。
In a subsequent data flow operation, you'll use a join operator to ensure that full XML account records (contained in the INFO column) are fed into the target data warehouse table.
在随后的数据流操作中，您将使用一个连接操作符确保整个XML账户记录(包含在info列中)被填充到目标数据仓库表中。
For each row ID, the FETCH operator reads the corresponding row from the table.
对于每一个行id,fetch操作符将读取表中相应的行。
This guideline specifies that all applicable XML indexes be used together by a XANDOR operator to access the given table.
该准则指定XANDOR操作符同时使用所有合适的xml索引访问给定表。
To mark a row within the query elements table as a column definition, the Operator choice for the row must be either asc for ascending or desc for descending.
要在查询元素表中将行标记为列定义，行的Operator选择对升序必须为asc，对降序必须为DESC。
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，散列连接列的值，并检查为内表生成的查找表。
Select a Table Source operator and drag it on the editor.
选中一个TableSource操作符并将其拖到编辑器上。
To only get current rules for each run, check the Delete previous content check box in the properties of the target table operator.
要想只获得针对每次运行的当前规则，选中表目标操作符属性中的Deletepreviouscontent复选框。
The extractor operator will extract the association rules form the PMML model created by the Associations operator and provides them in a relational table structure.
这个提取器操作符能从pmml模型(由associations操作符创建)提取关联规则并通过关系表结构提供这些规则。
Step 7: Adding a Table Join operator.
步骤7：添加一个Tablejoin操作符。
One operator is for data access from a table, one is for performing the segmentation, and the third is for visualizing the segmentation. Following are the steps for creating such a stream.
一个运算符用于来自表的数据访问、还有一个运算符用于执行细分、最后一个运算符用于可视化细分。
The remote query encapsulated by the leftmost SHIP operator is sent to the remote data source at which the US.Sales table resides.
由最左边的SHIP操作符封装的远程查询被转发到存放US. sales表的远程数据源上。
Edit the XML Relational Mapping operator, deleting all column definitions except those required by the target table.
编辑XMLRelationalmapping操作符，删除目标表不需要的所有列定义。
On the other hand, if you use the EXISTS operator, all rows are modified because at least one of the itemNumber values exists in the table subquery.
另一方面，如果使用EXISTS操作符，则将修改所有行，因为至少有一个itemNumber值存在于表子查询中。
The last operator in the flow is a table Target operator pointing to a table where you want to write the annotations.
数据流中的最后一个操作器是指向您希望写入注释的表的TableTarget操作器。
The earlier access plan shows that the total cost of the SELECT statement is 3420.41 timerons, which is from the table scan operator (TBSCAN) against the ACCOUNT table.
前面的访问计划显示select语句的总成本是3420.41timerons，这来自于表扫描操作符(TBSCAN)对ACCOUN t表进行的操作。
In the view below the editor, the Execution Status TAB is selected and on the right part of the view, you can see the table output of the last operator, that is, the Target table operator.
在编辑器下方的视图中，ExecutionStatus选项卡被选中并且在这个视图的右侧，还可以看见最后一个操作符(即Targettable操作符)的表输出。
For example, this was shown in the previous code listing, where the in operator selected all rows from the bigdog.products table that were produced by Quiet Beach Industries.
例如，如上一代码清单所示，In操作符选择bigdog .products表中由QuietBeach Industries生产的所有行。
Now define a Target table operator to populate the DWADMIN.HOLDINGS table by completing the following steps.
现在通过以下步骤定义一个Targettable操作符，用于填充dwadmin. holdings表。
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.
通过使用唯一的术语编号将表连接起来，为TableJoin操作符指定条件，术语编号为文本分析结果集中的SKILL_ID，和位于分类表中的TERM_ID。
This data flow simply reads the XML data from the source table and uses a single XML Relational Mapping operator to populate the target table directly, as shown in Figure 2.
这个数据流从源表中读取XML 数据，然后使用一个 XMLRelationalMapping操作符直接填充目标表，见图 2。
Right-click the output port (Inner) of the JOIN operator, and select Create suitable table from the context menu.
右键单击JOIN操作符的输出端口 (Inner)，然后从上下文菜单中选择Createsuitabletable。
Federated asynchrony can be recognized in execution plans by the existence of the new ATQ (Asynchronous Table Queue) operator directly above SHIP operators corresponding to remote operations.
通过对应于远程操作的SHIP操作符上的AT Q (asynchronousTableQueue)操作符，可以识别执行计划中的联邦异步。
Finally, create a suitable target table by selecting "create suitable table..." from the right-click context menu of the output port of the "Find Deviations" operator.
最后，从“FindDeviations”操作符输出端的右键菜单中选择“CreateSuitabletable…”，创建适当的目标表。
Right-click the first output port (Output) of the Regular Expression Lookup operator and select Create suitable table from the context menu.
右键单击RegularExpressionLookup操作器的第一个输出端口 (Output)，从上下文菜单中选择Createsuitabletable。
Connect the model and table source operator to the scorer.
将模型和tablesource操作符连接到scorer。
The access plan operator is either an action that must be performed on data, or the output from a table or an index.
访问计划操作符要么是必须在数据上执行的动作，要么是表或索引的输出。
To use a table subquery, you need to use an SQL operator to combine the embedded query with a Boolean expression.
要使用表子查询，需要使用SQL操作符将嵌入式查询与布尔表达式组合在一起。
应用推荐