Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning NC index seek vs NC index scan with implicit conversion RE: NC index seek vs NC index scan with implicit conversion

  • November 12, 2013 at 8:26 am

    #1665745

    Your sample set is way too small. Everything's fast on 10 rows.

    Estimated and actual rows will be the same for the seek and scan, because it's the number of rows returned by the operator, not the number of rows it read.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass