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
Change is inevitable... Change for the better is not.