Monday 28 October 2013

How does trace (and explain) SQL statements from SQL* plus?

Auto trace facility:
Set autotrace on
Select * from emp where empno =’7369’;

DBMS_XPLAN package:
Explain plan for Select * from emp where empno =’7369’;
Select * from table (dbms_xplan.diplay);

No comments:

Post a Comment