Closed Shop Order Mass Delete 关闭状态车间订单批量删除功能
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中,触发器的开销会很大。
应用推荐