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.
