Outer Web | Explore

Explore >> Select a destination

You are here		www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory	1.8 parsecs away Travel
\|	\|	There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID)....	1.8 parsecs away Travel
\|	\|	leonotes.wordpress.com ????(transitive closure)????????(Constraint-Generated Predicates) \| LEO Notes	1.6 parsecs away Travel
\|	\|	????????transitive closure?Wiki??????????Oracle????????...	1.6 parsecs away Travel
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	0.9 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...	0.9 parsecs away Travel
\|	\|	tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines????? \| Tony's Oracle Tips	15.0 parsecs away Travel
\|		Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...	15.0 parsecs away Travel