Embarcadero Understanding Oracle Optimizer Statistics

On Demand Webinar: Discover how to get better performance from your Oracle database


Whether you're a developer or a DBA, you want your application SQL to perform well and remain stable over time. You can stack the odds in your favor by Understanding Oracle Optimizer Statistics and how the optimizer formulates execution plans. The calculations the optimizer uses to make operation choices are rooted in some very simple statistical formulas. These formulas, if understood, can help you make better choices when tuning SQL and improve database performance over the long haul.

Register for the webinar on demand now to learn:

  • Oracle optimizer statistics fundamentals for computing cardinality/selectivity on single and multi-column predicates
  • How statistics can help the optimizer understand data distribution patterns
  • Reasons why certain ways of writing SQL limit the optimizer's ability and how query transformations improve the odds


    To watch this webinar on-demand, please fill out the form below. You will receive an email with a link to the webinar.


    First Name

    *

    Last Name

    *

    Company

    *

    Title

    *

    Email

    *

    Business Phone

    *

    Country

    *

    State or Province

    *


     

     

    About Karen Morton
    Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior DBA Performance and Tuning Specialist.
    For over 20 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a DBA, a data architect and now is a researcher, educator and consultant. Having used Oracle since the early 90's, she began teaching others how to use Oracle over a decade ago.
    Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network