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 6:08 pm

    #1732225

    kbhanu15 (7/14/2014)

    Hi ALl,

    Please give your suggestions to resolve this problem.

    Index Seek on Non Clustered Index cost is very high (92%) how to reduce this ?

    I've run into this in the past. Like Gail says, not enough information to call out a fix but, if it were me, I'd check the properties of the Index Seek in the execution plan and see how many times it's executing. If it's doing 1 seek per row instead of a single seek and a range scan, that could be one of the problems.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)