Outer Web | Explore

/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.dbaglobe.com Donghua's Blog - DBAGlobe: "HASH JOIN FULL OUTER" in explain plan (11g onwards) A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.	1.8 parsecs Travel
\|	\|
\|	\|	www.bobbydurrettdba.com Cardinality errors across joins \| Bobby Durrett's DBA Blog 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...	1.7 parsecs Travel
\|	\|
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0) A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.	1.6 parsecs Travel
\|	\|
\|	\|	savvinov.com DBMS_XPLAN.DISPLAY_CURSOR - Oracle Diagnostician In this post, I continue on the topic of examining SQL plans. I will talk about one DBMS_XPLAN function, DISPLAY_CURSOR (because it's probably the most useful one when troubleshooting ongoing performance issues, and also because other functions have a lot of similiarity to it). I will discuss frequently used options and some common problems. Preparation...	14.4 parsecs Travel
\|