A mass delete operates much more efficiently and writes considerably less log information.
mass delete执行起来要高效得多,并且要写的日志信息也更少一些。
If all rows in a table are deleted (known as a mass delete), all segments become immediately available for reuse at the COMMIT point, without requiring the REORG utility to be executed.
如果一个表中的所有行都被删除(即mass delete),则在执行COMMIT之际,该表所有的段就立即可以为其他表所用,而不需要执行REORG实用程序。
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中,触发器的开销会很大。
In a similar manner, you can break up mass UPDATE, DELETE or INSERT operations into separate jobs.
按照类似的方式,您可以将massUPDATE、DELETE或INSERT操作拆成多个不同的任务。
Mass updates using SQL searched UPDATE and DELETE techniques
使用SQL搜索的UPDATE和DELETE技术进行大规模更新。
Mass updates using SQL searched UPDATE and DELETE techniques
使用SQL搜索的UPDATE和DELETE技术进行大规模更新。
应用推荐