High number of executions in Key Lookup

[TimSki]

Hi,

In MS SQL server mangement studio i'm running a problem query and looking at the actual execution plan.

I've noticed that part of the plan (the most costly part) is a 'key lookup' on the table's clustered index.

Looking at the properties of this key loopkup everyhting seems reasonable. The only thing which looks wrong ?? is the 'Number of Executions' which is 8126.

Is this a problem. Elsewhere i generally see the number of executions = 1

Thanks in advance

[ck9663]

What does the query look like? One of the reason why you will see a "key lookup" on the execution plan is because you are accessing a column on the look-up table that is not included on the index key. If the processing is not being affected that much, you should be fine...

Good Luck!!!

~~ CK