DBA Hub

📋Steps in this guide1/1

xplain plan of a sql statement

Generate explain plan -- Syntax EXPLAIN PLAN FOR < SQL STATEMENT> ;

oracle configurationintermediate
by OracleDba
11 views
1

xplain plan of a sql statement

Generate explain plan -- Syntax EXPLAIN PLAN FOR < SQL STATEMENT> ; explain plan for select count(*) from dbaclass; View explain plan

Code/Command (click line numbers to comment):

1
select * from table(dbms_xplan.display);

Comments (0)

Please to add comments

No comments yet. Be the first to comment!