Updateable Join Views. High volume UPDATE statements with SET sub-queries can be one of hardest SQLs to tune. Consider the following: UPDATE my_table ...
www.orafaq.com