Why would SET ARITHABORT ON dramatically speed up a query?
- by Jonathan Allen
The query is a single select containing a lot of grouping levels and aggragate operations.
With SET ARITHABORT ON is takes less than a second, otherwise it takes several minutes. We have seen this behavior on SQL Server 2000 and 2008.