/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)
| | tanelpoder.com
How to resolve SQL object and column names all the way to base tables and columns in Oracle? | Tanel Poder Consulting
1.2 parsecs away

Travel
| | Update: As this original article is from 2007, there are better options available in the modern times for example DBMS_UTILITY.EXPAND_SQL_TEXT as explained by Maria Colgans blog entry here. If you have been involved in tuning SQL code which you have never seen before, you are probably familiar with the challenges of understanding what the code is trying to do. This can be especially time consuming when the SQL references lots of views, which reference views, which reference more views etc. So there may ...
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Explain Plan Lies
1.5 parsecs away

Travel
| |
| | leonotes.wordpress.com
(transitive closure)?(Constraint-Generated Predicates) | LEO Notes
1.3 parsecs away

Travel
| | transitive closure?Wiki?Oracle?...
| | oracle-randolf.blogspot.com
Oracle related stuff: Basic SQL statement performance diagnosis - HOW TO, step by step instructions
11.5 parsecs away

Travel
| On the OTN forum very often tuning requests about single SQL statements are posted, but the information provided is rather limited, and ther...