为什么查询超时?第2版

This Question

解决方案是,清除执行计划缓存在当时似乎是可行的,但我一次又一次地遇到同样的问题,清除缓存似乎不再有帮助。这里一定有更深层次的问题。

Linq查询和执行的SQL之间有什么区别?

我有一个短期的解决方法,那就是不使用.Distinct()作为列表返回集合,然后在列表上使用.Distinct,这大约需要2秒钟。但是,我不喜欢在web服务器上执行SQL Server工作。

更新:

当通过Linq执行代码时,sql事件探查器会显示此代码,这与查询基本相同。

sp_executesql N'SELECT DISTINCT [t5].[AccountGroupID], [t5].[AccountGroup] 
    AS [AccountGroup1]
FROM [dbo].[TransmittalDetail] AS [t0]
INNER JOIN [dbo].[TransmittalHeader] AS [t1] ON [t1].[TransmittalHeaderID] = 
    [t0].[TransmittalHeaderID]
INNER JOIN [dbo].[LineItem] AS [t2] ON [t2].[LineItemID] = [t0].[LineItemID]
LEFT OUTER JOIN [dbo].[AccountType] AS [t3] ON [t3].[AccountTypeID] = 
    [t2].[AccountTypeID]
LEFT OUTER JOIN [dbo].[AccountCategory] AS [t4] ON [t4].[AccountCategoryID] = 
    [t3].[AccountCategoryID]
LEFT OUTER JOIN [dbo].[AccountGroup] AS [t5] ON [t5].[AccountGroupID] = 
    [t4].[AccountGroupID]
LEFT OUTER JOIN [dbo].[AccountSummary] AS [t6] ON [t6].[AccountSummaryID] = 
    [t5].[AccountSummaryID]
WHERE ([t1].[TransmittalEntityID] = @p0) AND ([t1].[DateRangeBeginTimeID] = @p1) AND 
([t1].[ScenarioID] = @p2) AND ([t6].[AccountSummaryID] = @p3)',N'@p0 int,@p1 int,
   @p2 int,@p3 int',@p0=196,@p1=20100101,@p2=2,@p3=0

查询之间的唯一区别是Linq使用sp挈u executesql执行它,而SSMS不执行它,否则查询是相同的。

更新:

我尝试过各种事务隔离级别,但都无济于事。我还将ARITHABORT设置为在执行时强制重新编译,没有区别。