Can I tune the SELECT portion only for an INSERT statement?

No, the SELECT portion’s execution plan may be different when it is executed with the INSERT operation. We recommend to tune whole INSERT statement without splitting it into pieces.