Scan Coverage

The <scanCoverage> tag indicates whether the index scan for the query plan is “Covered” or “NonCovered”.

For more information on covered index scans, see “Indexes” in the Performance and Tuning Series: Locking and Concurrency Control.

Example

select show_cached_plan_in_xml(1139220075, 0)

<text>
<![CDATA[
SQL Text: select * from sysobjects group by name]]>
</text>
<IndexScan>
<VA>0</VA>
...
<scanCoverage> NonCovered </scanCoverage>
...
</IndexScan>