Loading

Query optimisation

rajaram mohanty

9y1.1kSQL

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.