Nice article, very elaborative.

I want to stress :

by improving performance, query will run faster and reduce required lock time, hence reducing blocking and deadlock posiibilities.

If you want to understand transaction processing, Thomas Kyte -- Expert Oracle .... is the book to study, a bible.