146 reputation
4
bio website
location
age
visits member for 2 years, 10 months
seen Oct 6 at 15:10

Sep
27
awarded  Popular Question
Dec
6
awarded  Supporter
Dec
6
awarded  Student
Dec
6
comment Why is Clustered Index Scan Number of Executions so high?
Clustered Index scan is on the subquery in the left join (PostNFIRSSummary)
Dec
6
comment Why is Clustered Index Scan Number of Executions so high?
Sure - I added the queries that are generating each plan.
Dec
6
awarded  Editor
Dec
6
revised Why is Clustered Index Scan Number of Executions so high?
Added example queries
Dec
6
asked Why is Clustered Index Scan Number of Executions so high?