Scan Count meaning in SET STATISTICS IO output: Part 2

In my last blog post, I had explained what Scan Count means and how it is calculated for a query executed on a table. I had illustrated a few examples based on seeks/scans done on Clustered Indexes of a table. This time I shall expand this to clustered indexes while performing joins. We shall use…

5

SCAN COUNT meaning in SET STATISTICS IO output

What does the Scan Count output in the SET STATISTICS IO output actually mean? I have seen multiple posts on the web regarding confusions and theories around this.   As per Books Online, Scan Count is: Number of index or table scans performed.   During the course of this post, I shall point out examples…