如何改进查询计划？

Question

我试图改善我的查询

SELECT top 100
    cr1.Id, 
    cr1.ArticleId, 
    cr1.CrossArticleId, 
    cr1.CrossesStatusId, 
    cr1.CrossesSourceId
FROM Detail.Crosses AS cr1
INNER JOIN Web.Detail.Article AS a1 ON a1.Id = cr1.ArticleId
INNER JOIN Web.Detail.Article AS a2 ON a2.Id = cr1.CrossArticleId

计划 在这里输入链接说明

我看到第二个连接不是最佳的。 201中有100个

我有两个索引，

CREATE UNIQUE NONCLUSTERED INDEX [UX_CrossesReverse] ON [Detail].[Crosses]( [CrossArticleId] ASC,   [ArticleId] ASC )

CREATE UNIQUE NONCLUSTERED INDEX [UX_Crosses] ON [Detail].[Crosses] ( [ArticleId] ASC,  [CrossArticleId] ASC )

请告知我我可以改进此查询计划