I have 2 (two) tables at this point of time i.e. main_result and update_result.
main_result has 10+ columns and 2 of them are "pk" (which is primary key) and "name". The update_result table contains records that need to be updated to the main_result table and it only has 2 columns i.e. "pk" and "name".
So, logically, I need to only update the name in the update_result table which has the same pk as the main_result table.
What would be the best and fastest SQL for me to update all the name in the update_result to the main_result? Considering that I have over 10 million records with many indexes in the main_result table.
View Complete Post