PeopleSoft Learning

 

Syntax to Build Explain Plan and view Output of Explain Plan in Oracle

 

Syntax to Build Explain Plan

 

Explain Plan for <SQL Statement>;

 

Example to build Explain Plan

 

Explain plan for select name from employee where eid=’2’;

 

Syntax to View Explain Plan 

 

Once the explain plan is build, to view the output, issue the following command:

 

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);

 

 

Thanks and Regards

D.Sasi Kumar