July 14, 2014 at 4:32 am
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 ?
July 14, 2014 at 4:55 am
No way to answer with that limited information. Please at least post the execution plan.
First though, is that a problem? The costs have to add to 100% across the plan, so is that seek problematic? Is the query even problematic?
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
July 24, 2014 at 4:37 pm
July 24, 2014 at 6:08 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply