Presentation Title: Oracle Optimizer: Harnessing The Power of Optimizer Hints
Speaker: Ms Maria Colgan, OakTable
Company: Oracle
Presentation abstract: 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
Related topics: Oracle RDBMS: Database Management, Oracle RDBMS: Features and Options, Oracle RDBMS: Performance Management
Hall: Hall 1