Back To Schedule
Wednesday, March 21 • 1:15pm - 2:15pm
Oracle Optimizer—Best Practices for Managing Optimizer Statistics

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
During the optimization of a SQL statement, the Optimizer relies heavily on statistics to estimate the number of rows produced by each of the SQL operators. The quality of the statistics for the objects referenced in the statement greatly affects the quality of the plan. Statistics maintenance is a challenge all DBAs must face in order to prevent the execution plan from becoming suboptimal. This presentation includes information on the features introduced in both Oracle Database 11g and 12c to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling and when, and how, to manually set statistics directly versus collecting them.

avatar for Maria Colgan

Maria Colgan

Master Product Manager, Oracle Corporation
Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments... Read More →

Wednesday March 21, 2018 1:15pm - 2:15pm MDT
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112