Delete,insert,update与undo的关系
What is relationship (delete,insert,update) and undo?
during an insert - we have togenerate undo equivalent to "delete+rowid"
during an update - we have togenerate undo equivalent to "update this rowid to have thesebefore image values" (undo = rowid + column before images)
during a delete - we have togenerate undo equivalent to "insert at this rowid thesevalues"
so,considering an unindexed table - IN GENERAL, a delete and update will generatethe most and an insert the least. IN GENERAL this is true (but not always).
INGENERAL=>delete>update>insert
if you add indexes - everything canchange. the insert might generate gobs of undo for the index maintenance -the update might not update any indexed columns and hence only generate undofor the table - and the delete might have to maintain all of the indexesgenerating tons of undo again.
so, it depends on the nature of the data,what you are inserting/updating/deleting..
same for redo. It depends on what is modified...
Add indexes
IN GENERAL=>delete>insert>update
总结:
通常情况下
Undo 产生量排序:delete>update>insert
Undo(table of indexes)产生量排序:delete>insert>update
一些手机发送业务上,往往会使用update去更新业务的状态!
转载TOM的文章:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5663330700346736253