Updated Intro to SQL tuning paper with example script and log

I’ve done an update on my introduction to SQL tuning paper.

Updated paper as of 05/29/2012

Example SQL script and its log – in zip with paper

I’ve added cardinality hint and breakup of a SQL query into smaller pieces with global temporary tables holding the results.  Hopefully I’ve cleaned up a few things.  Also put section headers to make the outline clear – intro, join order, join method, access method, conclusion.

– Bobby

About Bobby

I live in Chandler, Arizona with my wife and three daughters. I work for US Foods, the second largest food distribution company in the United States. I have worked in the Information Technology field since 1989. I have a passion for Oracle database performance tuning because I enjoy challenging technical problems that require an understanding of computer science. I enjoy communicating with people about my work.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.