Hi,
Below is the query which was running fine but when added Material_cd IS NULL, the performance was bad and was running more than 6 Hrs.
UPDATE f_cxs_oder_details j
SET j.estimated_gross_sales = j.channel_standard_value_usd / 0.49
WHERE (j.material_cd IS NULL) or TRIM (j.material_cd) IN
(SELECT TRIM (mat_sales.material_nr)
FROM d_csx_mat_sales mat_sales
WHERE mat_sales.sales_org_cd = 'B001'
AND mat_sales.disti_channel_cd = '01'
AND mat_sales.acct_assign_grp NOT IN ('01', '02'));
Please advice
Thanks
Aman