Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Index Seek on Non Clustered Index cost is very high (92%) how to reduce this ? RE: Index Seek on Non Clustered Index cost is very high (92%) how to reduce this ?

  • July 24, 2014 at 4:37 pm

    #1732217

    Add an unnecessary sort.

    That should make the index seek use proportionately less cost of the entire query.

    But, why would you want to?

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]