Here is the code inside my function:

        FOR temp_rec IN SELECT * FROM item_qc_doer LOOP
                DELETE FROM qc_session WHERE item_id = temp_rec.item_id;
                DELETE FROM item_qc_doer WHERE item_id = temp_rec.item_id;
        END LOOP;

Item_qc_oder table contains 22,000 records.

Also, chekc you have an index on both those item_id columns.

Also, why don't you just not use the loop and do this instead:

DELETE FROM qc_session WHERE item_id IN (SELECT item_id FROM item_qc_doer);
DELETE FROM item_qc_doer;


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to