Outer Web | Explore

Explore >> Select a destination

You are here		www.xt-r.com XT&R blackboard: nvl, coalesce ? concatenation
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	9.1 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...	9.1 parsecs away Travel
\|	\|	tanelpoder.com Sometimes things are easy (Part 1): How to fix wrapped execution plan text? \| Tanel Poder Consulting	12.4 parsecs away Travel
\|	\|	What you see below is a common problem. Someone sends you (or posts to a forum) a wide execution plan, which is unreadable because of wrapped lines. For example, this one below: -------------------------------------------------------------------------------- ------------------- \| Id\| Operation\| Name\| E-Rows \|OMem \| 1Mem \| Used-Mem \| -------------------------------------------------------------------------------- ------------------- \|0 \| SELECT STATEMENT\|\|\|\| \|\| \|1 \|SORT AGGREGATE\|\|1 \|\| \|\| \|*2 \|HASH JOIN\|\|...	12.4 parsecs away Travel
\|	\|	leonotes.wordpress.com ????(transitive closure)????????(Constraint-Generated Predicates) \| LEO Notes	7.6 parsecs away Travel
\|	\|	????????transitive closure?Wiki??????????Oracle????????...	7.6 parsecs away Travel
\|	\|	mauro-pagano.com Dynamic Sampling just got better \| Mauro Pagano's Blog	72.4 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...	72.4 parsecs away Travel