Difference Between Execution plan & Explain plan ?
Execution Plan?
* The execution plan for a SQL statement is a set of instructions.
* Tell the database how to access the data and join it together.
Explain Plan?
* An explain plan predicts how Oracle will process your query
* An execution plan describes the steps it actually took
No comments:
Post a Comment