How to use explain plan comand?

Questions by mkatpatal   answers by mkatpatal

Showing Answers 1 - 1 of 1 Answers

developer

  • Oct 11th, 2006
 

Hi Mukund,

Developers and DBAs use these tools to get the best performance out of their applications. The execution plan is made available to you in the form of rows inserted into a special table called a plan table.
Once you have access to a plan table, you are ready to run the EXPLAIN PLAN statement. The syntax is as follows:

EXPLAIN PLAN [SET STATEMENT_ID = <string in single quotes>]
   [INTO <plan table name>] FOR <SQL statement>;

Sri.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions