Improve the Update Query Performance

declare
    TYPE sample_tab IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
    
    type_sample_tab  sample_tab
    
begin
        SELECT  DISTINCT t1.ITEM_NAME
        BULK COLLECT INTO type_sample_tab
        FROM sample_staging_table t1
        WHERE
            t1.process_flag = 1
            AND t1.request_id = 70440789
            AND NOT EXISTS (SELECT
                                'X'
                            FROM
                                qp_list_headers_tl
                            WHERE
                                LANGUAGE = 'US'
                                AND NAME = t1.price_list_name
                            );

        FORALL i IN 1 .. type_sample_tab.COUNT
        UPDATE sample_staging_table
        SET error_message = 'RECORD NOT EXIST', process_flag = 3
        WHERE item_name = type_sample_tab(i)
        AND process_flag = 1
        AND request_id = 70440789;
end;

Select allOpen in new window

    UPDATE
        XXQP_EPM_PRICE_STG pbs
    SET
        pbs.process_flag = 3,
        pbs.error_message = 'RECORD NOT EXIST'
    WHERE
        pbs.process_flag = 1
        AND pbs.request_id = 70440789
        AND NOT EXISTS (SELECT
                            'X'
                        FROM
                            qp_list_headers_tl
                        WHERE
                            LANGUAGE = 'US'
                            AND NAME = pbs.price_list_name
                        );
end;

Select allOpen in new window