Understanding Oracle Optimizer Statistics

By: Tim DelChiaro

Abstract: Discover how to get better performance from your Oracle database

 Delphi XE3 - Your fastest path to Windows 8 and Mac

Stack your SQL Odds with Karen Morton 
on Tuesday January 29, 2013

 
 

Whether you're a developer or a DBA, you want your application SQL to perform well and remain stable over time. Stack the odds in your favor by understanding how the optimizer utilizes statistics to formulate execution plans. If understood, they can help you make better choices when tuning SQL and improve performance over the long haul.

Register for the webinar now to learn:

  • 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

blue_gelcap_button_register_now

 
 
register for webinar

Tuesday, January 29, 2013
7:00am PST / 10:00am EST 
11:00am PST / 2:00pm EST 


Register for the Webinar 
Learn how DB Optimizer tunes SQL Tune in for a live demo
of DB Optimizer
Embarcadero Developer Network Facebook Twitter YouTube

Server Response from: ETNASC02