Dan Hotka On Tuning SQL Statements
May 25th, 2004 by Mark Rittman
"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.
