Take a look at the SET SKIP command

>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.