Query optimisation

Aug 19 2017 7:03 AM
need help to optimisation .
 
And ISnULl(Org.CustomernKey,-99=ISNUll(ISNULL(Stg.CustomernKey,Org.CustomerNKey ),-99)

this setion of query running vary slow due to isnull may be.
 and this is defind in where cluse .
data passing from stagind table to main  but when this condition is check it getting slow .
 
 
so help me out  replace of isnull or any alternative 

Answers (2)