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've been working as an Oracle database administrator and PeopleSoft administrator since 1994. I'm very interested in Oracle performance tuning.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply