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.
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