This means that you should either load your data prior to creating your index or update the statistics on your table after your data is loaded.
这意味着您应该在创建索引之前加载数据，或者在加载数据之后更新表的统计信息。
If you hold CONTROL privilege on a table, you can update values that pertain to that table, but if you hold explicit DBADM authority on the database, you can change any updatable column.
如果在某个表上拥有CONTROL权限，那么就可以更新属于该表的值，但是如果拥有数据库上显式的DBADM授权的话，那么您可以更新任何可更新的列。
A database trigger is program residing in the database that runs when an event, such as an update, occurs on a table in the database.
数据库触发器是驻留在数据库中的程序，当数据库中的表发生更新之类的事件时会运行该触发器。
If an XML validation check constraint exists on the XML column of the table, the user may need to validate the new XML value before the update either manually or by creating a trigger.
如果在表的xml列上存在XML验证检查约束，在手动更新或者通过触发器更新之前，用户可能需要验证新的xml值。
If you need to update the copies loaded on the appliance, click the links to download the software catalog and PVU table.
如果需要更新加载到工具上的副本，单击链接下载软件目录和pvu表。
The two statements colliding are both UPDATE statements on table EMPLOYEE.
两条有冲突的语句都是表employee上的update语句。
This method takes three parameters, the primary key, the action performed on the table (create, update, delete) and a result set.
此方法具有三个参数，主键、对表执行的操作(创建、更新、删除)和结果集。
Matched rows in the target table are updated or deleted based on update or delete clause specifications, as shown in Figure 2.
对于目标表中匹配的行，将依据更新或者删除子句规范来进行更新或者删除，如图2所示。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
在我们对基准的第一个改进中，我们向账单表增加索引，并为表更新统计信息。
For example, it automatically executes the RUNSTATS utility on a periodic basis to update statistics about the physical characteristics of a table and the associated indexes.
例如，它周期性地自动执行RUNSTATS实用程序，以更新关于表及相关索引的物理特征的统计信息。
Update locks are held on the target table rows.
在目标表行上保持更新锁定。
The table name used on the UPDATE is the name of the file containing the format used in Listing 2.
UPDATE上使用的表名是包含清单2中使用的格式的文件的名称。
If we look at the update of the bill_items, all we are doing is updating a discount based on information from the customer table, which we had when we first built the bill_items table.
如果我们看一下对bill_items的更新，我们所做的就是基于来自customer表的信息来更新discount，这个我们在首次构建bill_items表时已经掌握了。
This method accepts two input arguments—the product ID and an array containing the revised record—and uses Zend_Db's update() method to execute an UPDATE query on the database table.
这个函数接收两个输入参数 —产品ID和一个包含修改记录的数组 —并使用 Zend_Db的update() 函数对数据库表执行一个 UPDATE查询。
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触发器。
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 触发器。
For example, if after a load all the data is on one partition and runstats is executed from another partition, it will update syscat.tables to show zero rows for that table.
例如，如果加载之后所有数据都在一个分区上，并从另一分区执行runstats，那么该命令将更新syscat .tables来表示该表的行数为零。
In the sample code, we have created three Triggers on the customer table for Insert, Update, and Delete.
在示例代码中，我们在customer表上创建了三个触发器，分别用于Insert、Update和Delete操作。
Right click on the GOSALES.PRODUCT table and select Update statistics as shown in Figure 22.
右键单击GOSALES . product表，选择updatestatistics，如图22所示。
Use the same process to refresh the current row counts for the GOSALES.PRODUCT_FORECAST table (right click on the table, select Update statistics, click in the SQL Results window).
通过同样的过程刷新GOSALES . PRODUCT _ forecast表的当前行数(右键单击该表，选择updatestatistics，在SQLResults窗口中单击鼠标)。
To keep the date-time stamp or version number accurate, you need to set up a trigger on the table to update it when a change to a row occurs.
为了确保日期时间戳或版本号的准确性，您需要在表上设置触发器，以便在发生对行的更改时，对日期时间戳或版本号进行更新。
Now let's start session 2 and have it update another row in the Orders table. Same situation – session acquires and holds X lock on the row with (ID = 2).
现在，我们开启会话2也更新订单表，不同的是更新的数据行为Id=2，同样的在数据行Id=2上也会申请排它锁至到更新事务的结束。
Is it better to create stored procedures for any required operations on a table in the database (e. g. create and read on this table, update and delete only on another one,...)?
这是更好地创建所需的任何操作在一个数据库中的表的存储过程(例如创建和读取此表，更新和删除只有一个，……)？
Example 2: you have a "last_login" field in your table. It updates every time a user logs in to the website. But every update on a table causes the query cache for that table to be flushed.
例2：一家包括“最后登录”字段的用户表，用户每登录网站都会要更新，而每次对表的更新都会导致这个表的查询缓存要刷新。
An update strategy is proposed based on the table structure to observe recommendation performance timely of peers who have record in the talbe.
针对上述表结构提出了一种更新策略，适时地考察表中节点的推荐性能。
An update strategy is proposed based on the table structure to observe recommendation performance timely of peers who have record in the talbe.
针对上述表结构提出了一种更新策略，适时地考察表中节点的推荐性能。
应用推荐