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.
通常情况下,在外部输入的基数显然不小且对于内部表没有一种有效的访问方法时,优化器会选择合并扫描联接。
In this case, he will locate the changes made to the CUST table and merge them into the production database.
在这个例子中,他将会确定cust表的修改,并将它们合并到生产数据库中。
However, the benefit of the merge scan join is that the inner table does not have to be scanned repeatedly as it does for nested loop joins.
然而,合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。
An external table cannot be a target table in the MERGE statement.
外部表不能是merge语句中的目标表。
In the first merge statement, all the non-matching rows would be ignored and matched rows would be updated in the sale table.
在第一个merge语句中,所有未匹配的行将被忽略,而销售表中匹配的行将被更新。
In the case of a mail merge, you define a data source document, which typically is a document with a table.
邮件合并时定义的数据源文档通常就是包含表格的文档。
So how can you optimize these kinds of tasks? For starters, there is more than one way to merge strings (see Table 5-1).
那么你怎样优化此类任务呢?首先,有多种方法可以合并字符串(见表5 - 1)。
Conceptually, the merge function joins source table rows with target table rows by applying the on clause filter. All the joined rows are updated or deleted on the target.
从概念上说,merge函数通过应用on子句过滤,将源表行与目标表行进行联接,所有联接的行都在目标中进行更新或者删除。
On the server with the target table, run the merge statements, as shown in Listing 14.
在目标表所在的服务器上,运行merge语句,如清单14所示。
For the merge statement that contains only the update clause or the delete clause, the inner join is performed between source and target table.
对于仅包含更新子句或删除子句的merge语句,内部联接会在源表与目标表之间执行。
Therefore during merge-insert operation, only for-each-row insert triggers on the target table are activated.
因此,在merge -insert操作过程中,仅激活目标表上的for - each -row insert触发器。
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语句)源与目标表行之间的联接。
Similarly, during merge-update and merge-delete operations, only for-each-row update or for-each-row delete triggers on the target table are activated.
类似地,在merge -update和merge -delete操作过程中,仅激活目标表上的for - each -row update或者for - each - row delete触发器。
This clause allows an SQL Table function to contain UPDATE, DELETE, INSERT and MERGE statements.
这个子句允许sql表函数包含UPDATE、DELETE、INSERT和merge语句。
Through to the encoder truth table characteristic analysis, has obtained the direct writing logical expression concrete method using the Karnaugh map most minor term merge rule.
通过对编码器真值表的特点分析,利用卡诺图最小项合并规则得出了直接书写逻辑表达式的具体方法。
MODIFIES SQL DATA in SQL table functions allows you to push even INSERT, UPDATE, DELETE and MERGE (data-change-operations) into the inner leg of correlated joins.
SQL表函数中的 MODIFIES SQLDATA使您甚至可以将INSERT、UPDATE、DELETE和MERGE ( 数据更改操作)放入到关联连接的内表中。
In this paper spatial data organization structure chart of seamless GIS is advanced, the point, line, area, complex feature, DTM data and attribute merge table of block are discussed in detail.
本文给出了无缝gis空间数据组织结构图,并详细列出了图块的点、线、面、复杂要素、DTM数据以及属性拼接表的数据结构。
You can use this method with a mail merge main document, a mail merge data source, or any document that contains data delimited by table cells or separator characters.
您可以将此方法用于合并列印主文件、合并列印资料来源,或其中含有由表格储存格或分隔符号所分隔之资料的任何文件。
The merge process could not adjust identity range resource for table '% 1'.
合并进程未能调整表“%1”的标识范围资源。
The following table lists the operators that support all merge option modes, subject to the specified restrictions.
下表列出所有支援合并选项模式的运算子,并指出每个运算子受到的限制。
Also, when a user upgrades from a previous version, the upgrade script will take their blogroll categories and merge them into the post category table.
同时,用户从先前的版本升级的时候,升级脚本会将友情链接类别合并到文章类别表格。
Also, when a user upgrades from a previous version, the upgrade script will take their blogroll categories and merge them into the post category table.
同时,用户从先前的版本升级的时候,升级脚本会将友情链接类别合并到文章类别表格。
应用推荐