Richard Foote

Richard Foote

Director & Principal Consultant


Based in Canberra, Australia, Richard has been working in the IT industry for over 30 years, 20 plus years with Oracle database technologies. Richard has supported and diagnosed the performance of numerous highly secure, mission-critical, large-scale applications. In 2002, he became a member of the world-renowned Oracle OakTable Network and an Oracle ACE Director in 2008. Richard is a very popular speaker and regularly presents at conferences including Oracle OpenWorld, IOUG Collaborate, Hotsos Symposium, AUSOUG InSync, ODTUG Kscope, UKOUG Conference, E4 Enkitec Extreme Exadata Expo and Trivadis Performance Days. He is especially renowned for his research and knowledge of Oracle indexing structures, hosts an internationally acclaimed blog on Oracle Indexing and has developed in-depth seminars on Oracle Indexing Internals which he has presented in some 20 countries. In 2017 Richard started his own independent consulting and training business ( and is planning on delivering his Oracle Index Internals training as a webinar in March 2019.


Oracle Database 18c and 19c New Indexing Related Features

Event: 2019 Webinar Series


The latest Oracle 18c and 19c Database releases have included a number of new indexing related features that help to maximise database and related application performance. This session will cover in some detail at some of these new features and capabilities, how they work and how they can be utilised to successfully improve performance. Some of the features to be discussed include the Memoptimized Rowstore, Scalable Sequences, Index/Partitioning Enhancements, JSON Indexing enhancements and one of the big 19c features, Automatic Indexing.