Need help regarding updating one table from another
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