This event has ended

Jonathan Lewis - "Indexing Strategies" webinar

Speak-Tech Webinars

Thursday, May 23, 2013 from 9:00 AM to 4:00 PM (CDT)

Jonathan Lewis - "Indexing Strategies"  webinar

Registration Information

Registration Type Sales End Price Fee Quantity
Indexing Strategies Webinar Ended $300.00 $0.00
Indexing Strategies & 2-day Oracle Mechanisms Recording
Indexing Strategies Webinar plus 2-day Oracle Mechanisms webinar recording
Ended $600.00 $0.00

Who's Going

Loading your connections...

Share Jonathan Lewis - "Indexing Strategies" webinar

Event Details

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.

Jonathan has long been a top presenter at IOUG, Oracle OpenWorld, UK Oracle User Group, and at User Groups everywhere. His very popular "Oracle Scratchpad" at jonathanlewis.wordpress.com is an excellent starting point for all things Oracle.

The cost of this webinar is $300. 

A recording of this webinar will be available to all attendees for free, unlimited playback for 30 days after it is available.

Please consider registering for the Indexing Strategies webinar and purchasing the recording of Jonathan's highly-rated, two-day  "Oracle Mechanisms" webinar presented April 11 & 12, 2013.  That's 3 days of world-class training by Jonathan Lewis for just $200 per day!

INDEXING STRATEGIES – AGENDA

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.

Topic 1

 

The Structure of Indexes

What is a B-tree index, what is a Bitmap index and why are the two so different? How does Oracle build indexes? Are there differences in reverse indexes, function-based indexes, cluster indexes, global partitioned indexes, indexed organized tables, and secondary indexes? With the aid of a few block dumps and carefully monitored test results we examine the way that different types of indexes are built and behave

 

Topic 2

 

The Uses of Indexes

How many different ways can Oracle take advantage of an index. We have primary keys and unique keys - do we need unique indexes to enforce them. We may have problems with foreign keys if we don’t have related indexes. We need optimal access paths – but will indexing help and what will it cost? When will Oracle use an index to accelerate a query? Can we assist performance by understanding the mechanisms.

 

Topic 3

 

Popular misconceptions

There are several surprising ideas floating around the Internet about how Oracle indexes work. Sometimes these ideas are irrelevant and have no use or impact. Sometimes they have a serious impact on your effectiveness. They may cause you to do work that need not, or should not, be done. They may introduce down-time that you do not need. They may make you avoid a feature that is really the perfect feature for your application. This session examines some of the more popular and potentially damaging misconceptions about indexes.

 

Topic 4

 

Maximum benefit, minimum cost

We all know that indexes are supposed to make things go faster – but sometimes we forget that they have maintenance costs – of two types. How do you identify the optimal set of indexes for your application? How do you identify redundant indexes? How do you check whether or not an index has become inefficient and needs to be rebuilt – and how do you rebuild it most cost-effectively? This session discusses strategies for ensuring that you don’t waste effort supporting indexes that shouldn’t exist, and don’t waste valuable batch time rebuilding indexes that don’t need it.

 
   
 
   
 
   
 
   

 

Have questions about Jonathan Lewis - "Indexing Strategies" webinar? Contact Speak-Tech Webinars

When

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

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.