/explore
|
You are here 
|
tonyhasler.wordpress.com | ||
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | [AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching. | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few... | |
| | | | |
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... | |
| | | | |
afatkulin.blogspot.com
|
|
| | | Most people are aware of the implication hot backup puts on your redo stream. They'll tell you that on first modification Oracle will dump t... | ||
