Oracle Mania
Saturday, 10 September 2016
How to get a explain plan for a query
1. Add "explain plan for" before select as "explain plan for select 'explain plan test' from dual"
2. And then execute "select * from table(dbms_xplan.display)"
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment