you are talking about Insert but attached a select statement. bit confused.

How is the insert happening? Through application or explicit insert statement?

Any Indexes on the table being insert?

Thanks,