SAN FRANCISCO – Jan. 24, 2013 – Embarcadero Technologies announced today it is hosting a free webinar titled "Understanding Oracle Optimizer Statistics" featuring DBA specialist Karen Morton. Two separate sessions will be held on Jan. 29, 2013.
What:
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.
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.
Webinar attendees will 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
When:
Tuesday, Jan. 29, 2013
7:00 a.m. PST/ 10:00 a.m. EST
11:00 a.m. PST /2:00 p.m. EST
Tuesday, Jan. 29, 2013
7:00 a.m. PST/ 10:00 a.m. EST
11:00 a.m. PST /2:00 p.m. EST
Where:
To register for a webinar session, visit: http://bit.ly/KarenMortonWebinar
To register for a webinar session, visit: http://bit.ly/KarenMortonWebinar
About the Presenter
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.
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.
About Embarcadero Technologies
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance, and accelerate innovation. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world.www.embarcadero.com
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance, and accelerate innovation. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world.www.embarcadero.com
source http://www.embarcadero.com
