/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

 sqlmaria.com
How to determine which view is the right view to use in Oracle?
| | www.bobbydurrettdba.com
Cardinality errors across joins | Bobby Durrett's DBA Blog
1.7 parsecs away

Travel
| | 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...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Performance Tuning using Windowing Aggregate Functions to avoid table self-join
1.8 parsecs away

Travel
| | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)
1.6 parsecs away

Travel
| | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.
| | hourim.wordpress.com
SQLTXPLAIN under Oracle 12c | Mohamed Houri's Oracle Notes
13.3 parsecs away

Travel
| I like very much Tanel Poder snapper and Carlos Sierra SQLTXPLAIN. They represent valuable performance diagnostic tools. Unfortunately I am still waiting to find a customer site where I will be allowed or granted necessary privileges to install and to use them. There are client sites where I have been asked to tune queries without...