Explore >> Select a destination
|
You are here 
|
tonyhasler.wordpress.com | ||
| | | | |
hourim.wordpress.com
|
|
| | | | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | |
| | | | |
alexzeng.wordpress.com
|
|
| | | | | Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | In response to a recent lamentation from Richard Foote about the degree of ignorance regarding the clustering_factor of indexes I commented on the similar degree of ignorance regarding the syntax of a specific hint, namely use_nl(a b), pointing out that this does not mean "do a nested loop from a to b". My comment was... | |
| | | | |
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 ... | ||
