Understanding Explain Plans & Index Utilization Online with Dan Hotka - 4-5 September 2012 September 4, 2012

This session starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. It goes into detail on how Oracle arrives at an execution plan, the explain plan. The trainer will illustrate various coding techniques that insure the SQL runs at maximum performance in the current and future Oracle database environments.
Indexes can greatly improve performance of SQL, but is this always the case? The answer will surprise you. Also, what is the ramification of too many indexes? Can too much of a good thing not be good? Again, the answer may surprise you. The trainer will illustrate various cost-based statistics that are useful to improve SQL performance and index selection as well. Understanding how Indexes work and when to use the different kinds of indexes is critical to both individual SQL performance and the overall batch cycle performance.

Official Website: http://bit.ly/dan-hotka-sep-2012