Outer Web | Explore

Explore >> Select a destination

You are here		mauro-pagano.com Dynamic Sampling just got better \| Mauro Pagano's Blog
\|	\|	blog.jooq.org What's faster, COUNT() or COUNT() with LIMIT in SQL? Let's check	3.0 parsecs away Travel
\|	\|	We check execution plans and benchmark results to see if using a LIMIT clause is useful when checking for existence of N values in SQL	3.0 parsecs away Travel
\|	\|	mahmoudhatem.wordpress.com Adaptive Dynamic Sampling : DYNAMIC_SAMPLING_RESULT & STALE_PERCENT \| Hatem Mahmoud's blog	1.5 parsecs away Travel
\|	\|	Since oracle 12.2.0.1 Adaptive Dynamic Sampling result are stored inside SPD as a special directive type "DYNAMIC_SAMPLING_RESULT". This will allow the result of ADS to be persisted on disk,thus it will survive memory flush and database restart.For more detailed info please check Mauro Pagano blog Post Something new about SQL Plan Directives and 12.2 We...	1.5 parsecs away Travel
\|	\|	leonotes.wordpress.com ????(transitive closure)????????(Constraint-Generated Predicates) \| LEO Notes	2.5 parsecs away Travel
\|	\|	????????transitive closure?Wiki??????????Oracle????????...	2.5 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com NLS \| Oracle Scratchpad	29.6 parsecs away Travel
\|		A couple of weeks ago, having just arrived home from Spain, I got a phone call in Heathrow airport from an old client that I hadn't seen for about 18 months. They had a problem; as far as they could tell a business critical query had suddenly stopped using an index and was doing a...	29.6 parsecs away Travel