Jonathan Lewis Consultant at Oracle Greater Los Angeles Area Information Technology and Services Jonathan has 6 jobs listed on their profile. Jonathan has 2 jobs listed on their profile. View Jonathan Lewis’ profile on LinkedIn, the world's largest professional community. Jonathan has 1 job listed on their profile. Filed under: Oracle — Jonathan Lewis @ 1:58 pm BST May 1,2020 In previous articles on reading execution plans I’ve made the point that the optimizer is very “keen” to transform complex queries into queries consisting of a single query block and that there’s a simple “First Child First (FCF)” rule for reading the plan for a single query block. It is dense, complicated material but Lewis nevertheless does his utmost to make it both clear and comprehensive. See the complete profile on LinkedIn and discover Jonathan’s connections and jobs at similar companies. View Jonathan Lewis’ profile on LinkedIn, the world's largest professional community. Jonathan Lewis’s most popular book is Cost-Based Oracle Fundamentals. Despite the differences in the software, he finds that the fundamental principles of solving performance issues don't really seem to change as you move from Oracle to SQL Server. Jonathan Lewis has 29 books on Goodreads with 800 ratings. Welcome This is the entry point for the Oracle Scratchpad - a static page that indexes various 'non-blog' pages on this site and a few other sites. Nobody (including those who programmed it themselves) understands the Oracle CBO better than Jonathan Lewis. View Jonathan Lewis’ profile on LinkedIn, the world's largest professional community. For the past 16 years, he has worked as a freelance consultant, often spending only one or two days at a time with any client to address critical performance problems. View Jonathan Lewis’ profile on LinkedIn, the world's largest professional community.
Jonathan has 6 jobs listed on their profile. 5 Replies Latest reply on Jun 21, 2013 8:19 AM by Jonathan Lewis Jonathan Lewis' presentation on Smarter Statistics in 11g 977635 Jun 18, 2013 6:40 PM Jonathan Lewis has been working in the information technology industry for nearly 25 years, and has been using the Oracle relational database management system for more than 20. Jonathan Lewis His specialist skills are in the area of physical database design, and solving performance issues. If you want to use the more traditional blog entry point you can bookmark this URL for If you want to make sense out of how and why Oracle chooses to execute queries in the way that it does, read this book.