The select statement graph

I will first start by presenting the  Select statement graph, with some essential cardinality formulas. Altough these formulas
will probably change from version to version, it’s important to remember them and understand the rationale behind them.

 

This select statement graph is drawn by compiling the information found in the following sources:

Jonathan Lewis
“CBO Fundamentals”

http://www.amazon.co.uk/Cost-Based-Oracle-Fundamentals-Experts-Voice/dp/1590596366

http://www.adellera.it

“New Density calculation in 11g”

http://www.centrexcc.com

“A Look under the Hood of CBO: The 10053 Event”
“Fallacies of the Cost Based Optimizer”
“Histograms – Myths and Facts”
“The Effects of optimizer_index_cost_adj and optimizer_index_caching on Access Plans”

Note for the reader: You should copy the picture on your disk  and zoom it bigger. I’m looking for the better solution to draw it at the moment