I am having a table with one billon rows. I want to update two columns of the table which don’t have index . Query is going for a table scan and my log is getting filled. I don’t have any joins on table ,it’s just a fixed value i want to assign to the columns.
Eg: update XYZ
Set column1 =’ABC’
Please suggest me some ideas to acheive it with minimum cost.
Please don’t me suggest me to do it in a batch and truncate the log after each update.