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.

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
Where:
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 90s, 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
Press Contact:
Kristina Lanpheir
Kulesa Faul for Embarcadero Technologies
831-251-9120
Email Contact
SOURCE: Embarcadero Technologies
http://www2.marketwire.com/mw/emailprcntct id=34F894FDDD131207

Featured White Paper

Meetings are where information and people collide. Although the technology has evolved to make it easier to collaborate with people from all over the world, providing video and fully integrated presentation capabilities such as ...