Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Non Clustered index on Primary key is not used by the execution plan and showing Table scan RE: Non Clustered index on Primary key is not used by the execution plan and showing Table scan

  • March 4, 2014 at 3:14 am

    #1693795

    ChrisM@Work (3/4/2014)

    Remove the index hint from the query whilst you are still testing and developing. Index hints are used when you've exhausted other, simpler, possibilities.

    Add rua.userIsBound to the index as an INCLUDE column.

    Then post the actual execution plan as a .sqlplan attachment.

    +1,

    "Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw 🙂