Outer Web | Explore

Explore >> Select a destination

You are here		tanelpoder.com How to resolve SQL object and column names all the way to base tables and columns in Oracle? \| Tanel Poder Consulting
\|	\|	nenadnoveljic.com Performance Improvement on Dictionary Views in Oracle 21c - All-round Database Topics	2.7 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.	2.7 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)	1.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.	1.2 parsecs away Travel
\|	\|	mauro-pagano.com "When the going gets tough, the tough get going" aka SQLT XPLORE \| Mauro Pagano's Blog	2.9 parsecs away Travel
\|	\|	When upgrading a database sometime you find that one or more SQLs run slower because ofa new and suboptimal execution plan. Usually the number of those SQLs is pretty small compared to the overall workload but it's not straightforward to understand what caused the plan change so even a small number can become tricky to...	2.9 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com Push_Subq \| Oracle Scratchpad	9.5 parsecs away Travel
\|		Another little warning for those about to upgrade from 9i to 10g. Some hints will change their behaviour. Consider the following SQL. By default if Oracle cannot unnest a subquery it postpones execution of that subquery to the end of the execution plan. I've used the no_unnest hint in the subquery to stop Oracle from...	9.5 parsecs away Travel