/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
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.1 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
| | 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...
| | www.bobbydurrettdba.com
Cardinality errors across joins | Bobby Durrett's DBA Blog
2.8 parsecs away

Travel
| | We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned...
| | jonathanlewis.wordpress.com
Bind Peeking | Oracle Scratchpad
14.6 parsecs away

Travel
| Here's a simple detail about bind peeking (during optimisation) that makes a big difference to "fetch first/next" queries. The optimizer knows about your bind types, and can peek at the bind values - but that doesn't mean it will do something sensible with them. Here's a little model to demonstrate the problem - starting with...