Microsoft Forum
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment