I'm inserting the data into the temp table and how does the index matter on the table to which the data is loading ?

Thanks for your reply though .

Sorry. I can't post the actual exec plan as it will have the table names.

And here are other attachments as well...