Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning NC Index Seek 51% and select cost 0%? RE: NC Index Seek 51% and select cost 0%?

  • July 15, 2013 at 4:36 am

    #1632385

    ChrisM@Work (7/15/2013)

    Edit - removed RESULTNUMBER, it's the cluster key.

    Why? What if someone changes the clustered index?

    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