ARITHABORT Performance RRS feed

  • Question

  • We are seeing better performance in a function with ARITHABORT ON than with it OFF. Any ideas why this is? The query plans for each are identical. I'm thinking ARITHABORT OFF it has to throw the error and "convert" the values to NULL, although I have no evidence of this. Any insight would be appreciated.

    Thanks in advance.
    Wednesday, August 29, 2007 6:31 PM