_gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(ga); })();
Entries categorized as Generating an EXPLAIN plan

Generating an EXPLAIN plan

On June 19, 2009 / By admin / In Oracle / No Comments
How would you go about generating an EXPLAIN plan?   Create a plan table with utlxplan.sql. Use the explain plan set statement_id = ‘tst1′ into plan_table for a SQL statement Look at the explain plan with utlxplp.sql or utlxpls.sql Read More...