Thanks

This is my execution plan.

regards,

M.H

Lowell,I put execution plan in the file, how can i attach it in this forum? I can't find any link for attaching here !?

Actually this is the time of my sp ! In my table "RecordFK" i have about 17million records , as i told you this table UNION with itself ! also...

Thanks my friends , all your guidance help me, I could decrease the time of sp from 184 seconds to 42 seconds by using covering index.

thanks a lot....

I have all indexes that you said Lowell !

I can explain more : there are an SP include INSERT INTO statement , In the SELECT FROM of INSERT INTO...