_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); })();

Generating an EXPLAIN plan

On June 19, 2009 / By admin / In Oracle / Reply

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

Related posts:

  1. Execution Plan What is Execution Plan ?   The combinations of...
  2. Types of SQL Statement What are the types of SQL Statement ?  ...
  3. Test plan attributes stored Where are the test plan attributes stored?   Test...
  4. Create and edit a test plan in Silk test How to create and edit a test plan in...
  5. Select a group of testcases in a test plan to run using Silk Test How to select a group of testcases in a...

Related posts brought to you by Yet Another Related Posts Plugin.

Reply

Spam Protection by WP-SpamFree