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

  • August 10, 2012 at 4:40 am

    #1524314

    HowardW (8/10/2012)

    It's not relevant how many rows were actually returned, it still has to access a range in the index if it's not marked as UNIQUE as it doesn't know how many rows may be returned until it's performed the seek.

    Please note that this is not the same as a table/index scan as you'd see it in an execution plan. It's still only scanning the rows that match the criteria...

    Thanks

    So anytime SQL has to access more that one page to return the desired result (irrespective of the number of rows returned). It counts as a range_scan ?

    I always though that a range_scan only happens when you have where column between 'some-value' and 'some value'

    Thanks for the clarification