1. They are the same ... move = delete + insert
2. Yes ... you're not just updating a single column and leaving the row in place, you're actually moving the row to a new block. You're also requiring that two partitions of every local index be modified




Reply With Quote