Explore >> Select a destination
|
You are here 
|
jonathanlewis.wordpress.com | ||
| | | | |
dioncho.wordpress.com
|
|
| | | | | One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the... | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | I have mentioned transitive closure in the past, and the commentson this blog item go into some depth about some of the effects of transitive closure. However, arecent incoming link has prompted me to point out a couple of further details about the appearance (or non-appearance) of transitive closure. We start with three (virtually) identical... | ||
