I need to update 70 million records every day ..
updating this based on between condition
Source (70 million as of now): CardNumber varchar(14)
Destination (10 million as of now): CardNumber_From varchar(14) , CardNumber_To varchar(14)
create clustered index idx on source(CardNumber )
create clustered index idx on Destination(CardNumber_fr,CardNumber_to )
update Source set Customeraddress= des.address ,customermobilenumber = des.mobileno
from Source sor join destinaion des
on sor.CardNumber between des.CardNumber_fr and des.CardNumber_to
Suggest me any fast approach to tackle this situation..