Upadate millions of rows
Hello world,
One of my developer require to update 10 million rows form one of the table (Tab1). To select this rows we have to make query and compare with another table(tab2).
Tab1 has 32 Million rows and Tab2 has 10 million rows.
To just query ( list this rows or count ) it takes around 3.5- 4 hours.
What would be the best option to perform this operation?
Thanks
Dev
One of my developer require to update 10 million rows form one of the table (Tab1). To select this rows we have to make query and compare with another table(tab2).
Tab1 has 32 Million rows and Tab2 has 10 million rows.
To just query ( list this rows or count ) it takes around 3.5- 4 hours.
What would be the best option to perform this operation?
Thanks
Dev
0