Outer Web | Explore

Explore >> Select a destination

You are here		tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines????? \| Tony's Oracle Tips
\|	\|	jonathanlewis.wordpress.com use_nl hint \| Oracle Scratchpad	2.5 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...	2.5 parsecs away Travel
\|	\|	dioncho.wordpress.com Interesting case of the restriction of global hints \| Dion Cho - Oracle Performance Storyteller	1.3 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...	1.3 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	2.6 parsecs away Travel
\|	\|	Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use...	2.6 parsecs away Travel
\|	\|	optimizermagic.blogspot.com Inside the Oracle Optimizer - Removing the black magic: Displaying and reading the execution plans for a SQL statement	18.9 parsecs away Travel
\|		Generating and displaying the execution plan of a SQL statement is a common task for most DBAs, SQL developers, and preformance experts as i...	18.9 parsecs away Travel