Can some one please explain a bit about explain plan, and how does one get the explain plan for a query. Also, if there is any sql script which can be used as utility for this, that would be great.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You can use the package DBMS_XPLAN:
Replace the ... with your SQL Statement. After running this run the following to view the plan: