On 07/23/2015 01:17 PM, twoflower wrote:
Hello, I have a table with 30 million records in which I need to update
a single column for a couple of thousands of rows, let's say 10 000. The
new column value is identical for all matching rows. Doing
|update "TRANSLATION" set fk_assignment where fk_jo
Hello,I have a table with 30 million records in which I need to update a
single column for a couple of thousands of rows, let's say 10 000. The new
column value is identical for all matching rows.Doing
update "TRANSLATION" set fk_assignmentwhere fk_job = 1000;
takes 45 seconds. I understand that
