I showed you how to tune an Update statement with a simple subquery in my last blog, a more complex update statement will be discussed in the following: update emp_subsidiary set emp_name=concat(‘Sub ‘,emp_name) where emp_id in (SELECT EMP_ID FROM EMPLOYEE,DEPARTMENT WHERE DPT_ID = EMP_DEPT AND DPT_AVG_SALARY<10000) Here the following is the query…