Further Reading

Virtual Conference 01 - Systematic SQL Optimization (18-19 Nov 2010)

A demo showing how the explain plan command may show you an incorrect execution plan - by Tanel Poder
Article about xm and xmsh scripts for querying V$SQL_PLAN directly, which also works on Oracle 9.2 - by Tanel Poder

Related article about other tools which use explain plan also possibly lying to you - by Charles Hooper

Read currently running SQL statement's bind variable values in Oracle 11.2 - by Tanel Poder
The most fundamental difference between HASH and NESTED LOOP joins - by Tanel Poder (read the comments, this topic isn't closed yet!)
A demo script showing that the bind variable peeking problem still exists in some cases even on Oracle 11.2 - by Tanel Poder
An example showing that an Oracle execution plan is just a bunch of C functions called in required order - by Tanel Poder

Out of Range predicates

Avoiding Tables

Bind variable problems

"Conditional" SQL

Questions & Answers

I will gather & paste these here tomorrow (Tuesday)!

Update: I've ran out of time - and I'll paste the Q&A info here on the weekend. Sorry for delay!

Update2: Still working on retrieving the questions - apparently there are some issues with getting them out of Gotowebinar properly.

Comments

	Search this site