Richard Foote
Richard Foote has been working in the IT Industry for over 22 years.
He got his first IT position as a humble Cobol Programmer,
and over the next 10 years he worked in various IT roles.
In 1997, he joined Oracle Corporation as a DBA specialist
and technical trainer. During his time at Oracle, Richard
became regarded as one of the leading DBA specialists and
instructors in Australasia, winning many internal awards.
In 1999 he won (along with Marcel Kratochvil) the second best paper
award at Australia's OpenWorld for their ground breaking "Good
DBA Bad DBA" presentation. In 2002 Richard left Oracle
to become an independent consultant and in 2006 his career
went full circle when he joined the Australian Public Service
as a DBA specialist and is responsible for many large scale, mission critical database systems. He's been a member of the Oracle OakTable Network since 2002 and currently maintains a very popular Blog focusing on Oracle Indexes (http://richardfoote.wordpress.com). In 2008, Oracle named Richard an Oracle ACE Director.
|
Oracle University exclusively presents
Database Expert Richard Foote!
Oracle Index Internals and Best Practices
31 August - 1 September 2009,
Singapore
Indexes are a crucial component in any Oracle database. This two-day
seminar is a detailed study of how various index structures
are implemented by Oracle, including B-Tree, Reverse Key, Function-Based,
Bitmap, Bitmap Join, Partitioned, Linguistic and Index Organized Tables.
It discusses index internals, how indexes should be maintained
and importantly examines how the Cost Based Optimizer determines
their use or otherwise.
The
seminar also dispels many common myths and misconceptions associated with Oracle indexes by proving index behavior with
clearly defined case studies and repeatable test examples. Featuring
many useful tips and tricks and current 11g new features, attendees
will gain a solid knowledge of the various Oracle index structures
and a clear understanding of appropriate index maintenance and
index usage strategies and best practices.
Objectives:
- Provide
a clear understanding of how Oracle implements its various index
structures and options
- How to
ensure indexes are used and maintained appropriately in their
database environments
- Help to
detect, resolve and prevent issues relating to indexes.
- Cover and
expose myths and misconceptions regarding Oracle indexes
- Provide a host of repeatable test cases to validate index behaviour and performance
Day 1:
- Introduction: Overview of Index Structures and Options
- Session One: Introduction To B-Tree Indexes
- Session Two: Index Statistics
- Session Three: Indexes and Constraints
- Session Four: Rebuilding, Coalescing and Shrinking
Indexes
- Session Five: Indexes And The Cost Based Optimizer
Day
2:
- Session
Six: Miscellaneous Index Tips, Tricks and Traps
- Session Seven: Linguistic Indexes
- Session Eight: Additional Indexing Options
- Session Nine: Partitioned Indexes
- Session Ten: Bitmap Indexes
Duration:
2 days |
Price:
SG$2274 |
Location:
Singapore |
Seats are limited for this seminar - so book your seat early!
To register:
call: 6436 2450
email: OUservices_sg@oracle.com
|
