Explore >> Select a destination
|
You are here 
|
chandlerdba.com | ||
| | | | |
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... | |
| | | | |
www.xt-r.com
|
|
| | | | | ?????? ????? ???? ????? ?? 11.2.0.3 ? ?????? ??????(V$SQL_HINT), ????? ?????? ?? ???????? ? ???? ??????? ???????, ??????? ??????????? ??????... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Here's a quick and dirty script I thought I'd published a very long time ago. It has to be run as SYS and queries v$sql_hint to produce a list of all the things which (at least in theory) could be used as hints somewhere in the code. I've ordered the list by the columns version... | |
| | | | |
tanelpoder.com
|
|
| | | Update: As this original article is from 2007, there are better options available in the modern times for example DBMS_UTILITY.EXPAND_SQL_TEXT as explained by Maria Colgans blog entry here. If you have been involved in tuning SQL code which you have never seen before, you are probably familiar with the challenges of understanding what the code is trying to do. This can be especially time consuming when the SQL references lots of views, which reference views, which reference more views etc. So there may ... | ||
