156 reputation
5
bio website
location
age
visits member for 3 years, 3 months
seen Mar 3 at 16:21

Feb
5
awarded  Nice Question
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?