Friday, January 29, 2021

Difference Between Execution plan & Explain plan ?

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