Explore >> Select a destination
|
You are here 
|
hourim.wordpress.com | ||
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | I was working on the example from an earlier blog post that showed how the optimizer could not correctly estimate the number of rows accessed on a table if the non-join condition was on a different... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | In an earlier articleI described how dbms_xplan.display_cursor() could be used to query memory to find the execution plans (and row source statistics) of recently executed SQL. In 9i, you have to use your own SQL to get the equivalent results. If you do, you should avoid using the "traditional" hierarchical type of query that you... | |
| | | | |
iggyfernandez.wordpress.com
|
|
| | | | | Dear NoCOUG members and friends, The golden rule of not tuning SQL is "operate with as little information as possible." Not only will this increase your chances of failure but it will make it difficult for others to help you. Every exercise in problem solving - no matter how little - has exactly six stages:... | |
| | | | |
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... | ||
