zipped

I think I'm losing my mind, I remove all unnecessary indexes, and optimize the remains but I couldn't still solve the problem. processor is still very high. For example I...

there was an index scan when I didn't use table hint. but I use table hint it turns to index seek and key lookup. but when I use only necessary...

I attached execution file .

I have been appling your recomendations to my queries. thank you so much. but I encounterd key lookup in execution plan and it's cost 100%. is it good or...

Thank you so much.

You gave me so valuable information thank you so much, but how can I decide which index or indexes must be deleted?

I attached my table and indexes scripts and an execution plan. Execution plan is related to an update query. this is a so sample query but it takes about 4-5...