/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: "HASH JOIN FULL OUTER" in explain plan (11g onwards)
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.bobbydurrettdba.com
Using coe_xfr_sql_profile.sql to force a good plan | Bobby Durrett's DBA Blog
12.8 parsecs away

Travel
| Sunday night we worked with Oracle Support on a performance issue with a query that had been running for over 14 hours even though it ran the previous weekend in five minutes. Oracle Support showe...