Forums - C# Corner

Forum guidelines
rajaram mohanty

rajaram mohanty

  • 1.6k
  • 1
  • 236

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)