/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

 connor-mcdonald.com
Kris Kringle the Database - Getting the BAND together - Learning is not a spectator sport
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)
1.5 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: New Implementation for Nested Loop Joins (11g onwards)
1.7 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.
| | dioncho.wordpress.com
Interesting case of the restriction of global hints | Dion Cho - Oracle Performance Storyteller
1.8 parsecs away

Travel
| | One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the...
| | savvinov.com
DBMS_XPLAN.DISPLAY_CURSOR - Oracle Diagnostician
13.8 parsecs away

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