Oracle DB Optimization Interview Question:

Explain Execution Plan?

Submitted by: Administrator

SQL Server caches the plan of execution of query or stored procedure which it uses in subsequent call.
This is a very important feature with regards to performance enhancement.
You can view execution plan of data retrieval graphically or textually.
Submitted by: Administrator