Explore >> Select a destination


You are here

hourim.wordpress.com
| | www.bobbydurrettdba.com
11.5 parsecs away

Travel
| | 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
6.4 parsecs away

Travel
| | 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
5.8 parsecs away

Travel
| | 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
62.1 parsecs away

Travel
| 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...