The most powerful way to alter an execution plan is via hints. But knowing when and how to use hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored. By attending this session you will arm yourself with the knowledge of how to apply the right hints, at the right time.

Presentation begins:

04/12/2012 09:55

Presentation duration:

60

Presentation content level:

2 (1 = indepth, 5 = strategic overview)

Audience experience:

All experience levels

Audience function:

Oracle, Partner, Product Expert, Product User

Speaker biography:

Maria Colgan is a senior principal product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibilities are the Oracle Optimizer statistics, and SQL Tuning. Based on Maria's extensive experience in Oracle's Server Technology Performance Group - where she conducted competitive customer benchmarks and tuning sessions - Maria creates and lectures on the Oracle Optimizer and the statistics that feed it. She is also a contributing author to the Oracle Optimizer blog http://blogs.oracle.com/optimizer.