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... | |
| | | | |
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
|
|
| | | | | 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... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | Here's a quick and dirty script I thought I'd published a very long time ago. It has to be run as SYS and queries v$sql_hint to produce a list of all the things which (at least in theory) could be used as hints somewhere in the code. I've ordered the list by the columns version... | ||
