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

 

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

 

 

 

0 comments: