If you are making a costly update in a big table (with several joins), you should consider to partition your table. In my case it was a great solution .

So,...