Home - Back
Jonathan Lewis

JL Computer Consultancy

About

Jonathan Lewis is a well-known figure in the Oracle world with more than 21 years experience of using the database (and several years on other products). He has published two books, ontributed to three others, runs a couple of websites and contributes fairly regularly to newsgroups, forums, User Group magazines, and speaking events around the world. Jonathan has been self-employed for most of his time in the IT industry. He specializes in short-term assignments, typically of a design, review, or trouble-shooting nature.

Website/Blog

Blog: http://jonathanlewis.wordpress.com/

Video
Jonathan Lewis at OOW2009
Track: ORA

Session title

Session description

The beginner's guide to becoming an expert

In this slide-free presentation Jonathan Lewis will discuss and demonstrate what it takes to become an expert in areas relating to Oracle performance. There will be NO "rocket-science" in this presentation, just simple demonstration and discussion. There will be plenty of time for questions and answers - and Jonathan Lewis will be asking most of the questions.

How to write efficient SQL

If you want to write an efficient query, you need to be familiar with the data, metadata, and the intent of the query. In this presentation we will discuss the information you need to know (or collect), and then explain how knowing this information will allow you to construct a "picture" of your query that allows you to identify the most efficient route to your final result.