This event has ended
Jonathan Lewis is one of the world's foremost Oracle experts and Oracle Magazine's 2006 "Oracle Author of the Year." He is a member of the prestigious Oak Table Network, a network for Oracle Scientists. His very popular "Oracle Scratchpad" is an excellent starting point for all things Oracle. Jonathan Lewis has been an independent design and troubleshooting consultant for more than 12 years. He runs JL Computer Consultancy www.jlcomp.demon.co.uk and specializes in knowing how the database engine works. If you need to know which features of Oracle may be useful for your specific application, Jonathan will be able to tell you because he spends a lot of time investigating how well new features work and how easy it is to break them. If you need to make your system run faster, he can tell you what can be done, and what is most likely to be a cost-effective approach. Each registrant receives a free copy of Jonathan's latest book "Oracle Core: Essential Internals for DBAs and Developers" a $31.91 value (or a $31.91 Amazon gift certificate)

Jonathan Lewis Oracle Performance Seminars - May 15-17, 2012 - Eagan, MN

Speak-Tech Webinars

Tuesday, May 15, 2012 at 8:00 AM - Thursday, May 17, 2012 at 4:00 PM (CDT)

Eagan, MN

Ticket Information

Ticket Type Sales End Price Fee Quantity
Designing Optimal SQL - TCOUG Member   more info Ended $300.00 $0.00
Cost-Based Optimization - TCOUG Member   more info Ended $300.00 $0.00
Designing Optimal SQL - Non TCOUG Member   more info Ended $350.00 $0.00
Cost-Based Optimization - Non TCOUG Member   more info Ended $350.00 $0.00
Buy Designing & CBO - TCOUG Member Ended $550.00 $0.00
Buy Designing & CBO - Non TCOUG Member Ended $600.00 $0.00

Share Jonathan Lewis Oracle Performance Seminars - May 15-17, 2012 - Eagan, MN

Event Details

Who should attend?

Experienced DBAs and Developers.

This is a fast-paced class and attendees should have a good understanding of Oracle.

 

Designing Optimal SQL- This tutorial has two targets. First: how do you improve the performance of a production system by attacking inefficient SQL; secondly: how do you design a system so that you can get data into and out of it efficiently. For most people, the design has already happened, nevertheless you need to be aware that the two targets overlap significantly - as you struggle to address a particularly inefficient piece of SQL, you need to be aware that there are structural features of the database that may help you find a cost effective solution despite the problems imposed by the SQL itself.

The course will focus on the SQL - falling back to structural issues only as an aid to improving the mechanical efficiency of the SQL solution - but we will spend some time explaining the pros and cons of various structural options as they become relevant to the SQL.

The course will cover methods of reviewing data distribution patterns, use of indexes, use of views (stored and inline), analytic functions, subquery factoring, as well as statistics, hints, and a brief review of execution plans.

 

Indexing Strategies - One of the most important, yet overlooked, aspects of efficiency is the need for a good indexing strategy.

Indexes improve the speed of queries, but increase the cost of DML. Given a thorough understanding of indexes you have the option for deciding the optimal set of indexes to suit the needs of your application. Everything you might want to know about indexes will be in this tutorial.

 

Cost-Based Optimization - Is there a go_faster parameter? Which parameters affect the Cost Based Optimizer (CBO) most? Just how does Oracle decide whether or not to use an index? Why does Oracle do a Hash Join instead of a Nested Loop? Why is Oracle ignoring my hints?

All these, and many other questions about the working of the Cost Based Optimizer will be answered by this tutorial.

Have questions about Jonathan Lewis Oracle Performance Seminars - May 15-17, 2012 - Eagan, MN? Contact Speak-Tech Webinars

When & Where



Thomson Reuters
Thomson Reuters
610 Opperman Drive
Eagan, MN 55123

Tuesday, May 15, 2012 at 8:00 AM - Thursday, May 17, 2012 at 4:00 PM (CDT)


  Add to my calendar

Organizer

Speak-Tech Webinars

Speak-Tech is Minnesota-based and has organized webinars and seminars featuring the world’s leading Oracle experts for over 12 years.

Speak-Tech has organized over 100 training events for experts such as Jonathan Lewis, Tom Kyte, Cary Millsap, Tim Gorman, Gaja Krishna Vaidyanatha and David Kurtz, considered to be some of the world’s leading experts in Oracle Performance Tuning; Syed Jaffar Hussain, Oracle ACE Director who was awarded the Oracle Excellence Award for Technologist of the Year: DBA, 2011; Steven Feuerstein, considered to the world's leading expert in PL/SQL, Jim Czuprysnski and Matt Hart, all leading experts in their Oracle specialties.

  Contact the Organizer
  News and Updates
Friday, April 27, 2012 - 5:05 AM

Jonathan Lewis "Indexing Strategies" - May 16, 2012 at Thomson Reuters in Eagan is SOLD OUT.  Add your name to the wait list and you will be contacted if a seat becomes available.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.