dbms_xplan.display_cursor will output the hints for a plan.
These hints can then be taken and used in an outline for plan stability:
top of page
Recent Posts
See AllThis is more of a bookmark for a future blog post on using the Cardinality hint. This post by Greg Rahn give some example and I posted in the comments some more detailed examples: http://structureddat
bottom of page