Richard Foote

Richard Foote 300x300

Richard Foote

Director & Principal Consultant

Richard Foote Consulting

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

Optimizer Statistics: The Key To Efficient, Scalable Databases and Applications

Event: Virtual Connect 2020, Virtual Connect 2020-Cloud
Stream: Architecture, Cloud Database & Technology

One of the more common reasons why SQL statements run inefficiently is due to poor execution plans as a result of optimizer segment statistics that are either missing, inaccurate, incomplete, misleading or potentially too accurate for its own good. In this presentation we examine a number scenarios where SQL execution plans are inefficient due to deficiencies in the underlining segment statistics, how they can be addressed with appropriate statistics gathering processes and how more recent statistics gathering features and capabilities such as adaptive statistics, real-time statistics and high frequency statistics gathering can assist in enabling a more stable and performant database environment.