Forums - C# Corner

Forum guidelines
rajaram mohanty

rajaram mohanty

  • 1.5k
  • 1
  • 133

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)