Outer Web | Explore

Explore >> Select a destination

You are here		nenadnoveljic.com WINDOW SORT PUSHED RANK Performance Regression in Oracle 21c - All-round Database Topics
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	3.2 parsecs away Travel
\|	\|	When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...	3.2 parsecs away Travel
\|	\|	dioncho.wordpress.com Interesting case of the restriction of global hints \| Dion Cho - Oracle Performance Storyteller	3.5 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...	3.5 parsecs away Travel
\|	\|	mauro-pagano.com Dynamic Sampling just got better \| Mauro Pagano's Blog	3.2 parsecs away Travel
\|	\|	12c brought several new features in the SQL performance area and the most advertised one is probablyAdaptive Query Optimization. The Adaptive Plans feature has been described in a lot of details (specially the adaptive join methods part) and most of the focus in Adaptive Statistics has been on SQL Plan Directives and Automatic Re-optimization, not...	3.2 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com use_nl hint \| Oracle Scratchpad	25.2 parsecs away Travel
\|		In response to a recent lamentation from Richard Foote about the degree of ignorance regarding the clustering_factor of indexes I commented on the similar degree of ignorance regarding the syntax of a specific hint, namely use_nl(a b), pointing out that this does not mean "do a nested loop from a to b". My comment was...	25.2 parsecs away Travel