Explore >> Select a destination
|
You are here 
|
jonathanlewis.wordpress.com | ||
| | | | |
mauro-pagano.com
|
|
| | | | | 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... | |
| | | | |
tonyhasler.wordpress.com
|
|
| | | | | 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... | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | 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... | |
| | | | |
blog.yannickjaquier.com
|
|
| | | JSON datatype has been introduced with Oracle database 21c. Is promising JSON performance worth moving your column to this new datatype ? | ||
