I have a table A which has Id = 0 for some 6k records, another table B in which these IDs are missing. I want to insert these IDs into table B with an auto incremented ID number and update these ID numbers into table A in no particular order. just that there should be no ID = 0 in table A. I'm doing this in Python. is there a faster way of doing this rather than the regular DMLs and for loop which seems to be taking a very long time.
Thanks in advance.