| |
|
|
|
|
|
|
|
|
Wednesday, May 16th 2012 |
|
|
|
|
|
8:00 AM - 8:30 AM |
|
Check-In and Complimentary Breakfast |
|
|
|
|
|
|
|
|
|
8:30 AM - 10:00 AM |
|
Session 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. |
|
|
|
|
|
|
|
|
|
10:00 AM - 10:30 AM |
|
Break |
|
|
|
|
|
|
|
|
|
10:30 AM - 12:00 PM |
|
Session 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. |
|
|
|
|
|
|
|
|
|
12:00 PM - 12:45 PM |
|
Complimentary Lunch |
|
|
|
|
|
|
|
|
|
12:45 PM - 2:15 PM |
|
Session 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. |
|
|
|
|
|
|
|
|
|
2:30 PM - 4:00 PM |
|
Session 4 - Maximum Benefit, Minimum Cost |
|
|
|
|
Fixing the code without touching the code - the latest options, including a little time looking at the ways in which you can use OEM to assist with tuning. Problems and options with knowing internal mechanisms and taking advantage of them. A look at a couple of popular requirements, and strategies for addressing them as efficiently as possible. And a final look at the threats of hints and how to use them properly |
|
|
|
|
|
|
|
|
There are no seminars on the
calendar at this time.
View all Seminars |
