Loading…
View analytic
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 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.

Speakers
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. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product. Prior to this role she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer. Maria is the primary author of the SQLMaria blog at https://sqlmaria.com and a contributing author to the Oracle Optimizer... Read More →



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