Index Stats

<< Click to Display Table of Contents >>

Navigation:  In Memory Tables >

Index Stats

Scanning Large Part of the Index


If the rows returned is greater than scans started this indicates scans are scanning a large part of the index.


This occurs when a query performs a point lookup but reverts back to a full index scan.


With hash indexes this can occur when there is more duplicate indexes.




Scans Started

Number of in memory OLTP index scans. Note this also includes scans for inserts.

Scans Retries

Number of index scans needed to be retried

Rows Returned

Cumulative number of rows returned since starting SQL Server or the table was created. Note scans for insert do not return any rows.

Rows Touched

Cumulative number of rows accessed since starting SQL Server or the table was created