| http://www.w3.org/ns/prov#value | - There are some cases where a clustered index (or nonclustered index) scan can abort early, he is usually due to TOP or some constructs of Row_number.The Actual rows is always the rows returned, not the rows read, so if there is a predicate on that scan, it is the number of rows that qualified for the predicate, not the number read from the table.The sheet subtitle says Scanning a clustered index,
|