File Library


Designing Efficient SQL
Topic: Kscope14 Recordings
Owner: Jonathan Lewis
Date: 2014-06-25
Subtopic: Developer's Toolkit

When the requirements get complicated there is a straighforward strategy to writing efficient SQL that will reduce the amount of time you lose trying to get the database to do the right thing; but it requires knowledge of the data, the metadata, and the intent of the query.

In this presentation I start with the basic principle of efficient data access; then look at ways of analysing the data (in case you are not familiar with it already); finally I outline the principle of efficient data access, using a graphical approach to model a query, and finish with a small example
from a production system I was called to review some time ago.


Download File   JLewis.DesigningEfficient.pdf
Download File   Designing Effecient SQL-DevTools.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database