[jwr]

Of course you update indexes in a transaction. Doing this manually has a lot of advantages, some of which I outlined in my other comments in this thread.