Hotsos Training Day

Jonathan Lewis-2009Hotsos is very pleased to announce that Jonathan Lewis is this year's Training Day speaker scheduled for March 8, 2012.


Jonathan Lewis is a well-known figure in the Oracle world with more than 24 years experience using the software. He has published three books about Oracle - the most recent of which (Core Oracle) was scheduled for publication by Apress in Nov 2011 - and contributed to three others. He runs a couple of websites and contributes fairly regularly to newsgroups, forums, and User Group magazines and events around the world.

Jonathan has been self-employed for most of his time in the IT industry. For the last eighteen years, he has specialized in short-term assignments, typically of a design, review, or trouble-shooting nature - often spending no more than two or three days on a client site to address problems. He runs seminars about using Oracle all over the world and has visited 50 different countries (and a dozen states in the USA) to talk about, or trouble-shoot, Oracle systems. For working in the USA, he is covered by an O1 visa - granted only to "aliens of exceptional ability".

Jonathan was a founding member of the Oak Table network, and one of the first individuals to be contacted by Oracle University for their "Celebrity Seminar" events.


Designing Optimal SQL is the topic for Training Day.

Jonathan will review various uses of indexes, including some of the less common uses. He will also discuss ideas and methods for investigating and understanding the data and business requirements.

He will teach you how to approach the task of translating business requirements into SQL and emphasize the need for clarity in code, providing suggestions and justifications for standards of presentation to improve ease of understanding. He will give an introduction to the essential strategy for writing SQL that gets its result by doing the minimum of work.

Jonathan will conduct a brief discussion of the mechanics (and costing) of nested loop, merge, and hash joins, and explain why it is so easy for the optimizer to pick the wrong option. He will demonstrate a few examples of classic problems and show you the solutions that take advantage of some of the slightly exotic options of SQL and Oracle's available features.

He will demonstrate the need for front-end code to cooperate with the database engine in certain circumstances. You will be encouraged to think about indexes as if they are just another table – making a query more complex to make it faster. Jonathan will go over profiles and baselines as well as the hints that Oracle uses, and he will provide a closing look at the potential risks of hinting and how to do it properly.


Training Day will begin at 8:30 a.m. and end at 4:45 p.m.


  • $500

Registration Cancellation Policy

  • 100% refund if cancelled on or before December 31, 2011
  • 50% refund if cancelled between January 1, 2011 and February 10, 2012
  • Cancellations submitted February 11, 2012 and after will not be refunded