Hi All,

i have a parent table from which i want to update one column in a child table.

The parent table has 34 columns and child table has 12 columns.
Matching key between 2 tables is a composite key consisting of 3 columns.

Both the tables contain around 70000 records.

I want to update one column of child table from parent table based on the composite matching key consisting of 3 columns.

This matching key is the primary key for child table but not for parent table.

Hence i cant update the child table using a single SQL command as there are multiple records in parent table for the matching key combination.

Presently i am updating the child table using a CURSOR FOR LOOP. But this is taking hell lot of time around 3-4 hrs.

Can somebody tell me an optimised way of doing this task.

Thanking in Advance,
Swaraj