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		leonotes.wordpress.com (transitive closure)?(Constraint-Generated Predicates) \| LEO Notes
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Performance Tuning using Windowing Aggregate Functions to avoid table self-join 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
\|	\|
\|	\|	dioncho.wordpress.com Interesting case of the restriction of global hints \| Dion Cho - Oracle Performance Storyteller 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...	1.4 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.3 parsecs Travel
\|	\|
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Using "nonunique index to enforce uniqueness" is a good way? A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.	13.3 parsecs Travel
\|