哪种DML操作产生undo多
on the type of transaction being performed:
Deletes are expensive for rollback segments; they need to store the actual row itself. If you can use TRUNCATE instead, performance is improved.
Inserts use little rollback space; only the rowid is kept.
The amount used for updates depends on how many columns are being updated.
Indexed values generate more rollback, because the server process must change values
in the index as well as in the table. For updates on indexed columns, the Oracle server
records in the rollback segment the old data value, the old index value, and the new
index value. Updating rows that change partitions will also generate more rollback.
Direct path inserts / appends / loads are not likely to use much rollback.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25744374/viewspace-720747/ ，如需转载，请注明出处，否则将追究法律责任。
