Training Services

I currently present a fully updated and revised version of the very popular and successful “Oracle Indexing Internals and Best Practice” 2 day seminar, which has previously been run in some 18 countries A must for every Oracle DBA, Developer, Solution Architect or anyone interested in designing, developing or maintaining high performance, highly scalable Oracle-based applications. This seminar examines most available Oracle index structures/options and discusses in considerable detail how indexes function, how/when they should be used and how they should be maintained. A key component of the seminar is how indexes are costed and evaluated by the Cost Based Optimizer (CBO) and how appropriate data management practices are vital for an effective indexing strategy. Many Oracle databases/applications are currently running sub-optimally with inefficient workloads directly as a result of implementing an inappropriate indexing strategy. The seminar covers many useful tips and strategies to maximise the benefits of indexes on database/application performance and scalability, as well as maximising Oracle database investments. Much of the material is exclusive to this seminar and is not generally available in Oracle documentation or in Oracle University courses.

For full details of the “Oracle Indexing Internals and Best Practices” seminar, see the Indexing Seminar page.

The seminar is developed and personally delivered by Richard “Mr Index” Foote, a well-respected expert in Oracle Database technologies. and is currently scheduled in the following locations:

Consulting Services

Well-tuned Oracle Databases are obviously crucial for any organisation with benefits that include:

Better end-user experiences

More scalable and resilient applications

Maximise investments in both Oracle licensing and current infrastructure

Avoid or delay infrastructure upgrades or increases in licensing requirements

Reduced subscription requirements in Cloud-based migrations

Based on over 20 years experience in managing, tuning and trouble-shooting Oracle Databases, Richard Foote has tuned and successfully addressed complex performance issues for numerous Oracle customers. In many cases, this has resulted in 10+ times performance improvements and in some scenarios the cancellation of planned infrastructure upgrades.