Hello, everyone. I have a many-to-many relation (e.g. driver_id, car_id)

Question

Hello, everyone. I have a many-to-many relation (e.g. driver_id, car_id)

in my db. I want to update multiple records in this table (e.g. where driver_id = 123). I get a single driver id and a list of car_id's in every request. My 1st approach is to delete all the records for that single driver and insert back again the new records. 2nd approach is to create another staging table for all incoming records before I finally merge it into my main table with the help WHEN NOT MATCHED THEN INSERT ... and WHEN NOT MATCHED BY SOURCE THEN DELETE;

What is the best way to accomplish this task in terms of performance? Ответ можете дать на русском.

#programming #russian #sql

0

22.08.2021