Since those triggered actions are typically one or more insert, UPDATE, or DELETE statements, the overhead of triggers can be substantial in a mass insert operation.
由于那些被触发的动作通常是一条或多条insert、UPDATE或delete语句,因此,在数据量很大的insert中,触发器的开销会很大。
Given the number of INSERT, UPDATE, and DELETE operations and changes in data distributions, you need to collect the right statistics regularly and with minimum resource consumption.
您需要根据INSERT、UPDATE和DELETE操作的数目和数据分布的变化,在资源消耗尽量少的情况下定期收集正确的统计数据。
This feature enables you to batch multiple INSERT, UPDATE, and DELETE requests even when they reference multiple tables.
这个特性允许您对多个INSERT、UPDATE和DELETE请求进行批处理,即使它们引用多个表。
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them.
在某种程度上,SQLupdate语句是SQLINSERT和delete语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
Heterogeneous batching can potentially improve the performance on INSERT, UPDATE and DELETE statements that operate on multiple tables.
异构批处理能够潜在地提高在多个表上对语句进行INSERT、UPDATE和DELETE操作时的性能。
You can also perform INSERT, UPDATE, and DELETE operations for relational nicknames, but not for non-relational nicknames.
对于关系昵称,也可以执行INSERT、UPDATE和DELETE操作,但是对于非关系昵称不可以执行这些操作。
To avoid too much complexity, DB2 imposes a simple rule: an UPDATE, DELETE or INSERT (data-change-operation) shall never happen in a join unless embedded in a correlated function.
为了避免太多的复杂性,DB 2强加了一条简单的规则:除非嵌入在相关的函数里面,否则UPDATE、DELETE或INSERT(数据更改操作)不应该出现在连接中。
In trigger terminology, the INSERT, DELETE, or UPDATE that causes a trigger to be fired is known as the triggering event.
在触发器术语中,INSERT、DELETE或者UPDATE这些使得触发器启动的事件被称作触发事件。
After the execution of the UPDATE, INSERT, and DELETE statements, an additional variable is available to check the result of the statement.
执行完update、INSERT和delete语句后,将使用额外的一个变量来检查语句的结果。
For every row that moves, there are two actions - insert and delete.
对于所移动的每一行,有两个动作—insert和delete。
Since this is a table operation, tooling generates insert, update, and delete operations automatically.
由于这是一项表操作,因此工具将自动生成insert、update和delete操作。
We discovered that there is a point where aggregate index costs—more-expensive INSERT and DELETE operations, for example—outweigh a new index's query speed-up benefit.
我发现有一个聚合索引成本的点 —例如,更为昂贵的INSERT和DELETE操作 —超出一个新索引的查询加速所能带来的效益。
The old version of the redistribute utility USES special insert and delete with sub-select statements.
旧版本的重分发实用程序通过子选择语句使用特殊的insert和delete。
For each IfxDataAdapter, define the SQL text and parameters for the select, insert, update, and delete commands.
对于每个IfxDataAdapter,需要定义SQL文本,并为select、insert、update和delete命令定义参数。
These re-usable data adapters can have select, update, insert, and delete commands that are either SQL statements or stored procedure calls.
这些可重用数据适配器可以拥有select、update、insert和delete命令,它们或者是sql语句,或者是存储过程调用。
It introduces the XQuery transform expression which USES four updating expressions — insert, delete, replace and rename to modify the XML document fragments.
它引入了XQuerytransform表达式,该表达式使用4个更新表达式——insert、delete、replace和rename来修改XML文档片段。
In the AddressPropertyManager class, the generated code has placeholders for the get/update/delete/insert operations for all the properties.
在AddressPropertyManager类中,生成的代码包含用于所有属性的get/update/delete/insert操作的占位符。
It provides the functions for executing the SQL select/insert/update/upsert/delete statements via the Teradata DBC/SQL partition.
它提供了通过TeradataDBC/SQL分区执行 SQLselect/insert/update/upsert/delete语句的功能。
In the sample code, we have created three Triggers on the customer table for Insert, Update, and Delete.
在示例代码中,我们在customer表上创建了三个触发器,分别用于Insert、Update和Delete操作。
In a similar manner, you can break up mass UPDATE, DELETE or INSERT operations into separate jobs.
按照类似的方式,您可以将massUPDATE、DELETE或INSERT操作拆成多个不同的任务。
The informational constraints are not enforced by the federated server during operations such as insert, delete and update.
在诸如insert、delete和update操作期间,联邦服务器不施加信息约束。
In addition, triggers can now contain UPDATE, DELETE, and INSERT operations together in a single clause as the trigger event. For example.
另外,触发器现在可以在单一子句中同时包含UPDATE、DELETE和INSERT操作,作为一个触发器事件。
UPDATE is an INSERT, UPDATE, DELETE, or MERGE operation that may have input parameters and that returns an integer (number of affected rows).
更新是一个INSERT、UPDATE、DELETE或MERGE操作,可以有输入参数,返回一个整数(受影响的行数)。
When a specified SQL operation — a DELETE, INSERT, or UPDATE — occurs on a table, a trigger can be activated that defines a set of actions.
当一个指定的SQL操作(如DELETE,INSERT,或者是UPDATE操作)作用于某张表时,一个定义了一组操作的触发器就可以被激活。
Now you can add images to the Delete Row and Insert Row buttons to make them look more attractive.
现在,可以向DeleteRow和Insert Row按钮添加图像以使它们看起来更有吸引力。
The application demonstrates how to perform basic record operations such as (insert, update, delete) on sales-related data.
这个应用程序演示如何在销售相关数据上执行基本记录操作(比如insert、update、delete)。
Specifications for the representation of SQL actions (insert, update, delete).
SQL动作(insert、update、delete)表示的规范。
Notice the use of the index function within the at attribute of the insert and delete actions.
请注意insert和delete动作的at属性内index函数的使用。
In real life, you would rarely want to drop an existing database but merely INSERT and DELETE from tables.
在现实生活中,您不太会drop现有的数据库,而只是从表中INSERT和DELETE。
SELECT, however, isn't the only SQL statement supported by YQL; you can also use INSERT, DELETE, and UPDATE queries to manipulate data on third-party services using the same SQL syntax.
但是,SELECT并非YQL支持的惟一SQL语句;您还可以使用INSERT、DELETE和UPDATE查询、运用相同的 SQL语法操作第三方服务上的数据。
应用推荐