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请求进行批处理,即使它们引用多个表。
Heterogeneous batching can potentially improve the performance on INSERT, UPDATE and DELETE statements that operate on multiple tables.
异构批处理能够潜在地提高在多个表上对语句进行INSERT、UPDATE和DELETE操作时的性能。
In most cases, well-suited SQL statements are very simple SELECT statements that reference only a single table or are INSERT, UPDATE, and DELETE (UID) operations that are executed many times.
在大多数情况下,非常适合使用参数标记的sql语句要么是非常简单的SELECT语句(只引用一个表),要么是被多次执行的INSERT、UPDATE和DELETE (uid)操作。
For INSERT, UPDATE, and DELETE queries involving nicknames, in some cases (explained below), all the work might be done by the remote data source, and a SHIP operator will not be found in the FQEP.
对于使用了昵称的INSERT、UPDATE和DELETE查询,在某些情况下(后面会解释),所有工作可能都是由远程数据源来做,而在FQEP中没有ship操作符。
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活动的数据库提供很好的保护。
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语句,或者是存储过程调用。
The previous examples are fairly simple, but GroovySql is just as solid when it comes to more complex data manipulation queries such as insert, update, and delete queries.
前面的例子相当简单,但是GroovySql在处理更复杂的数据操纵查询(例如insert、update和delete查询)时,也是非常可靠的。
If there were a trigger, for example, you would see that reflected in one or more additional insert, Update, or Delete entries in the access plan.
例如,如果有一个触发器的话,那么就会在访问计划中的一个或多个insert、Update或Delete条目中反映出来。
However, REFRESH IMMEDIATE system-maintained MQTs are updated with changes made to the underlying tables as a result of insert, update, or delete operations.
但是,对于REFRESHIMMEDIATE 类型的系统维护的MQT,可以通过对底层表的更改(即insert、update或delete 操作)来更新。
The application demonstrates how to perform basic record operations such as (insert, update, delete) on sales-related data.
这个应用程序演示如何在销售相关数据上执行基本记录操作(比如insert、update、delete)。
From an SQL perspective, the merge statement is a DML SQL statement with the same semantics as other DML statements, including insert, update, and delete.
从SQL的角度看,merge语句是与其他dml语句具有相同语义的DML sql语句,包括insert、update、以及delete。
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操作的占位符。
For each IfxDataAdapter, define the SQL text and parameters for the select, insert, update, and delete commands.
对于每个IfxDataAdapter,需要定义SQL文本,并为select、insert、update和delete命令定义参数。
In the sample code, we have created three Triggers on the customer table for Insert, Update, and Delete.
在示例代码中,我们在customer表上创建了三个触发器,分别用于Insert、Update和Delete操作。
In theory, you can perform select, insert, update, or delete statements against a table that is not yet redistributed in the database partition group.
理论上讲,可以在数据库分区组中尚未重分发的表上执行select、insert、update或delete语句。
The informational constraints are not enforced by the federated server during operations such as insert, delete and update.
在诸如insert、delete和update操作期间,联邦服务器不施加信息约束。
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语句的功能。
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)表示的规范。
It could be an insert, update, or delete.
该命令可能是insert、update或delete。
You will be able to select from the nickname but not insert/update/delete with it.
您可以对昵称使用select 语句,但是不能使用 insert/update/delete 语句。
The DBMS ensures that the index is always consistent with the data in the table by updating it during INSERT, UPDATE, and DELETE operations.
通过使用INSERT、UPDATE和DELETE操作对索引进行更新,DBMS能够确保索引始终与表数据一致。
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 触发器。
应用推荐