Performance Tips for select count update insert

Use Merge command

Avoid select count statement.

Always minimize and simplify your query.

Don't make it complex. 

Minimize the execution of same statement