SQLTeam.com | Weblogs | Forums

Index seek 60% usage


How to improve performance further when IDX seek is taking more cost. 60% of the total SP execution time. IS there anyway to further tune any Idx seek ...by modify the idx cols etc.


How many rows is it returning?
Is the index maintained well?

Table partition can also help.

Other questions to ask...

How many times is the index seek actually being executed? Is it doing a nice sorted range scan from there or looking up thousands of rows one at a time?