如果从一个带有10个索引的表删除一行，DB 2必须删除与被删除的行关联的所有索引条目。
Delete a row from a table with 10 indexes, and DB2 must remove all index entries associated with the deleted rows.
重命名旧的删除表。
因此，需要通过定期清理步骤表来删除不需要的条目。
Therefore, you should periodically prune the steps table to remove unwanted entries.
清单7演示了从指定的工作表删除最后一行的过程。
Listing 7 illustrates, by deleting the last row of a specified worksheet.
存档之后，从审计日志表中删除老的条目。
Once archived, those old entries are removed from the audit log tables.
删除目标表不需要的所有结果集列。
Delete all result set columns except those required by the target table.
发出下面的命令来检查是否为表空间启用了对被删除表的恢复支持，如果没有启用，就打开它。
Issue the commands below to check whether a table space is enabled for dropped table recovery and if not, turn it on.
您可以应用规范化的概念删除表的冗余部分，然后将它们放在次表中。
You could apply the concept of normalization to remove redundant portions of the tables and place them in secondary tables.
那意味着，无论何时添加或删除分区，都必须在分区表的所有现有索引中添加或删除对应记录。
This meant that whenever partitions were added or removed, corresponding records had to be added to or removed from any indexes that existed for the table.
TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
然而，这个注册表变量只能在实例启动时生效，所以，如果您想修改DB2在mdc表上的删除操作方面的行为，必须重新启动实例。
However, this registry variable can only take effect on instance startup, so if you want to alter the behavior of DB2 with respect to deletions on MDC tables, you have to restart the instance.
“数据删除”指定从此表中删除数据的时间间隔。
Data delete specifies the interval at which data from this table is deleted.
可以在原来发布服务的注册表中删除服务，也可以在服务被同步到的注册表中删除它们，这两种情况有很大差异。
There is a big difference between deleting services in the registries where they were originally published, versus deleting services in registries where they were synchronized to.
如果没有包括任何where子句，则删除表中的所有行。
If no WHERE clause is included, all rows in the table are deleted.
后面的方法对于等待分离完成的自动化非常有用，这有助于序列化目标表上的后续活动(例如，删除或者归档)。
The latter method can be particularly useful for automating the wait for completion of detach to help serialize the subsequent action (for instance, drop or archive) on the target table.
由于这些表持续增长，所以wip操作员需要定期将已废弃的信息从这些表中删除。
Since these tables keep growing, the WIP operator needs to periodically remove from these tables the information that is obsolete.
而且要能够对过去仓库处理活动的任何历史加以恢复；备份文件应该包含从档案表中删除的数据。
And also that any past history of the warehouse processing activity can be recovered; backup files should contain the data that has been deleted from the archive table.
日期和时间应该早于运行错误的应用程序(即删除表中的行)的时间。
The date and time should be prior to when the bad application ran (when you deleted the table rows).
但是，一般地，您不希望删除表中的所有行；而是有选择地删除行。
In general, however, you don't want to delete all rows from a table; instead, you'll selectively delete rows.
此列捕获从系统周期时态表中删除该行时的时间戳。
This column captures the timestamp when the row is deleted from the system-period temporal table.
在DB2中运行在线备份的惟一约束是：当一个表空间正在被备份的时候，不能删除这个表空间。
The only restriction when running an online backup in DB2 is that you cannot drop a table space while that table space is actively being backed up.
正被删除的类型化表不能拥有任何子类型。
The typed table that is being dropped cannot have any subtables.
基于被修改复制表的新模式创建一个新的删除表。
Creates a new delete table based on the new schema of the altered replicated table.
现在，在被删除表的ddl语句清单中创建被删除的表。
Now, create the dropped table from the list dropped table DDL statement.
表中信息的添加、删除和更新将导致数据变得杂乱，检索杂乱的数据更为费时。
Additions, deletions, and updates of information in the tables cause the data to become disorganized, and retrieving disorganized data is more time-consuming.
从您装载的表中删除被修剪过的行，确保以后不会将重复的行装载到表中，这是一种很好的做法。
It is a good practice to delete any pruned rows from the table that you loaded in order to ensure that you do not load duplicate rows into the table at a later time.
还可以添加和删除DB 2表中的条目。
结果我们比以前多了很多的表，但添加和删除索引却很容易。
As a result, we end up having more tables than we had before, but adding and removing indexes is easy.
确信服务器有足够的锁资源数，用以修改相关的删除表和复制表。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
清单4中在新创建的临时表上演示了删除表的过程。
The process of dropping a table is demonstrated on a newly created temporary table in Listing 4.
应用推荐