How to reduce the Index Seek cost ? my index seek is taking 87% ?

  • hi All,

    Please provide the possible options to reduce the Index Seek Cost ?

  • First things first. Is that a problem? Is that query a problem?

    If not, why are you worrying about it? The % cost has to be somewhere, it is a percentage.

    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
  • This depends on a whole lot of factors, you're just not giving enough information.

    Anyway, an index seek means the index is being used for what is has been build, so that's usually a good thing.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • And remember, those costs are just estimated values. They don't represent a literal real-world performance metric. It's just a measure of what the optimizer thinks a given operation will cost based on the operation and the statistics presented to the optimizer.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply