Explore >> Select a destination
|
You are here 
|
www.xt-r.com | ||
| | | | |
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... | |
| | | | |
dioncho.wordpress.com
|
|
| | | | | One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the... | |
| | | | |
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... | |
| | | | |
hoopercharles.wordpress.com
|
|
| | | May 9, 2010 (Back to the Previous Post in the Series)(Forward to theNext Post in the Series) Continuing the true or false blog article series with more questions that seem to have conflicting answers,if the answers to those questions depend on the source of the informationfound through Internet searches. Today's quiz is on the topic... | ||
