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