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
‹
›
Home
View web version
No comments:
Post a Comment