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操作,但是对于非关系昵称不可以执行这些操作。
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语句后,将使用额外的一个变量来检查语句的结果。
Incremental backup is a good way to protect a database that is largely read-only but has some occasional INSERT, UPDATE, or DELETE activity performed against it.
增量备份能够为以只读为主、偶尔执行INSERT、UPDATE或DELETE活动的数据库提供很好的保护。
For every row that moves, there are two actions - insert and delete.
对于所移动的每一行,有两个动作—insert和delete。
The old version of the redistribute utility USES special insert and delete with sub-select statements.
旧版本的重分发实用程序通过子选择语句使用特殊的insert和delete。
Since this is a table operation, tooling generates insert, update, and delete operations automatically.
由于这是一项表操作,因此工具将自动生成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语句,或者是存储过程调用。
For each IfxDataAdapter, define the SQL text and parameters for the select, insert, update, and delete commands.
对于每个IfxDataAdapter,需要定义SQL文本,并为select、insert、update和delete命令定义参数。
The application demonstrates how to perform basic record operations such as (insert, update, delete) on sales-related data.
这个应用程序演示如何在销售相关数据上执行基本记录操作(比如insert、update、delete)。
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操作的占位符。
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操作 —超出一个新索引的查询加速所能带来的效益。
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操作期间,联邦服务器不施加信息约束。
Neither REFRESH DEFERRED nor REFRESH IMMEDIATE system-maintained MQTs allow insert, update, or delete operations to be executed against them.
不管是REFRESHDEFERRED还是REFRESHimmediate类型的系统维护的MQT,对它们的insert、update或delete操作都是不允许的。
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操作,可以有输入参数,返回一个整数(受影响的行数)。
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。
You will be able to select from the nickname but not insert/update/delete with it.
您可以对昵称使用select 语句,但是不能使用 insert/update/delete 语句。
You can now define multiple INSERT, DELETE, UPDATE, and SELECT triggers on a table and multiple INSTEAD OF triggers for the view.
现在可以在一个表上定义多个INSERT、DELETE、UPDATE和SELECT触发器,也可以在一个视图上定义多个INSTEADOF 触发器。
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 ( 数据更改操作)放入到关联连接的内表中。
应用推荐