kyle HaileySep 4, 20091 min readOutlines from DBMS_XPLANdbms_xplan.display_cursor will output the hints for a plan.These hints can then be taken and used in an outline for plan stability:http://oracle-randolf.blogspot.com/2009/03/plan-stability-in-10g-using-existing.html
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:http://oracle-randolf.blogspot.com/2009/03/plan-stability-in-10g-using-existing.html
Oracle’s Cardinality Hint, Profiles, Outlines and SQL BaselinesThis 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...
Comentários