Explore >> Select a destination
|
You are here 
|
www.xt-r.com | ||
| | | | |
chandlerdba.com
|
|
| | | | | In my previous post, I wrote about the time I made a mistake specifying a hint via a SQL Patch, meaning it "didn't work". This leads to an understanding about the classification of hints - some hints are used for the Optimizer/CBO, but other hints have different reasons for being used. For example APPEND is... | |
| | | | |
mauro-pagano.com
|
|
| | | | | When 12.2 came out most of the (optimizer) focus was around SPD and how to avoid the challenges from 12.1. Still 12.2 introduced several (less acclaimed) optimizations including "Bushy Join" transformation, which is interesting since (I think, corrections welcome) Bushy Join concept isn't necessarily tied to query transformation in general, especially before 12.2 (some reference... | |
| | | | |
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... | ||
