Home Forums SQL Server 2008 SQL Server 2008 Administration Index Range_scans RE: Index Range_scans

  • August 10, 2012 at 4:16 am

    #1524303

    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