NOT EXISTS replace with NOT IN

[ales]

Change the qualifier of the column in the subquery to csm2:

AND NOT EXISTS
( SELECT csm2.sty_dsp_nbr

This might lead to better plan.

Hard to give another advice without knowledge of the logic behind the data etc.