Home Forums SQL Server 2008 SQL Server 2008 Administration Index Range_scans RE: Index Range_scans
HowardW
One Orange Chip
Points: 29109
More actions
August 8, 2012 at 6:06 am
#1523067
Because it's not a UNIQUE index, so it's retrieving a range of values that match your criteria rather than a singleton lookup.