Explore >> Select a destination

You are here

 jonathanlewis.wordpress.com
Re-partitioning 2 | Oracle Scratchpad
| | nenadnoveljic.com
Undocumented Implicit Partition Statistics Gathering - All-round Database Topics
4.4 parsecs away

Travel
| | A boundary condition where subpartition statistics gathering can also trigger partition statistics
| | hourim.wordpress.com
How to attach a hinted SPM baseline to a non hinted sql query? | Mohamed Houri's Oracle Notes
4.3 parsecs away

Travel
| | 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...
| | antognini.ch
Partition-Wise Operations - New Features in 12c and 18c - Striving for Optimal Performance
4.3 parsecs away

Travel
| |
| | alexzeng.wordpress.com
Outline, SQL profile and SQL Plan Management(SPM) | Alex Zeng's Blog
19.5 parsecs away

Travel
| 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...