Diffrent execution plan = Bad performance.

  • Thread starter Thread starter Fredrik Melin
  • Start date Start date
F

Fredrik Melin

Hi,

When running a query in Query analyzer (SQL Server 2000) I dont get the same
execution plan as If I run the query to a DataReader object in .NET
framework.

Anyone know why execution plan differ between those two?

I get very poor performance in .NET due to this.

Regards
Fredrik Melin
 
Found it:

Query analyzer has arithabort = on
Sql Server has arithabort = off default, and that is what .NET was using.
 
Bob has also found similar problem in thread
HELP serious performance degradation compared to QA

from 6.1.
 
Back
Top