The Optimizer Internals with Joze Senegacnik, De Meern June 14, 2010

This 1-Day seminar is prepared for developers and DBAs in order to help them to understand how the Cost Based Optimizer works. The goal of the seminar is to reveal the basic mechanisms in cost based optimization, the initialization parameters that influence the CBO, SQL statement transformation, execution plan preparation, optimization and plan stability. Although the process of statistics and histogram gathering is automated there are many situations when certain exceptions are required in order to feed CBO with the proper information. The optimizer hints are really not hints but rather directives and should be therefore properly used. In this seminar we briefly discuss also the ways for physical layout optimization and access path optimization.

Official Website: http://cli.gs/EUNHMp