• Blog Post: 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 the...
  • Blog Post: 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...
Page 1 of 1 (2 items)