Outer Web | Explore

Explore >> Select a destination

You are here		jonathanlewis.wordpress.com Ignoring Hints - 2 \| Oracle Scratchpad
\|	\|	www.bobbydurrettdba.com Cardinality errors across joins \| Bobby Durrett's DBA Blog	9.1 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...	9.1 parsecs away Travel
\|	\|	nenadnoveljic.com Performance Improvement on Dictionary Views in Oracle 21c - All-round Database Topics	9.6 parsecs away Travel
\|	\|	Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD.	9.6 parsecs away Travel
\|	\|	leonotes.wordpress.com ????(transitive closure)????????(Constraint-Generated Predicates) \| LEO Notes	4.6 parsecs away Travel
\|	\|	????????transitive closure?Wiki??????????Oracle????????...	4.6 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)	25.2 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.	25.2 parsecs away Travel