Friday, February 18, 2011

How to explain Query

Step 1) Statement id has to be passed it can be any alpha numeric combination

EXPLAIN PLAN
SET STATEMENT_ID = 'abc' FOR
SELECT * FROM emp WHERE deptno=20

Step 2)
SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','abc','ALL'));

No comments:

Post a Comment