I have a parent table P2 and two related child tables C1 and C2.
Each table has in excess of 1 million records. After SETting
the RELATIONs, how can I examine only those records in the
children tables that should be constrained to the parent relationship?

Based on the child related info, I will update a field in the
parent table.