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.

Column	Description
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