Richard Foote

Richard Foote

Director & Principal Consultant

Biography

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 (www.richardfooteconsulting.com) and is planning on delivering his Oracle Index Internals training as a webinar in March 2019.

Papers

10 Things You Might Not Know But Really Should About Oracle Indexes (Connect 2019)

Event: Connect 2019, Melbourne-Connect-2019, Perth-Connect-2019

Stream:Architecture, Cloud Database & Technology

An appropraite indexing strategy is crucial in ensuring that both databases and their associated applications perform as efficiently as possible. This presentation will look at 10 Oracle indexing related features and capabilities that might not be very widely know, but can be extremely important for both DBAs and Developers to understand and appreciated when designing and tuning efficient and highly scalable Oracle database-based applications. Topics include the use to TABLE_CACHED_BLOCKS when collecting index related statistics, the use of Partital Indexes, the importance of the table Clustering Attribute and the correct strategy when ordering columns within an index.