Explore >> Select a destination
|
You are here 
|
nenadnoveljic.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... | |
| | | | |
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... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Okay, so the title is pretentious; but I thought it was a snappy summary of this item [until someone pointed out that Heisenberg's Uncertainty Principle is not about measurement error]. I've blogged before about the improved features in 10g of the dbms_xplan package, in particular the display_cursor() procedure, with its option for displaying rowsource execution... | |
| | | | |
afatkulin.blogspot.com
|
|
| | | Take a look at the following table: SQL> create table codes 2 ( 3 code varchar2(10), 4 used number, 5 constraint pk_cod... | ||
