Thursday, June 27, 2013

Performance issue with ISNULL function

I am using MS SQL server 2008R2 - enterprise edition and the main table have around 100 million records. If I use 'ISNULL' or 'OR', it take me around 6 hours. but if I remove this logic, it just take me 30 minutes.

No comments:

Post a Comment