HowardW (8/8/2012)
Because it's not a UNIQUE index, so it's retrieving a range of values that match your criteria rather than a singleton lookup.
Thanks
I don't understand this because my result returns one value
Why does it show a Range_scan?
Thanks