I would like to know better solution to update 180K records in one table from another in sql
no performance issue, it should be faster.
mostly like first update 500 records wait for 1 min then update next 500 till I reach my no fo records present in table