Dan Hotka On Tuning SQL Statements

"Tuning problematic SQL statements is neither rocket science nor magic. All relational databases generate an execution plan for the submitted SQL. This execution plan then tells Oracle how to retrieve the data, or, how to perform the data-related tasks. The better you understand how to interpret these explain plans, the better you can resolve possible performance issues with the SQL." explains Dan Hotka in "SQL Statement Tuning Tips and Techniques" for DBAZine.com.