Oracle DB Optimization Question:
Download Questions PDF

Explain Execution Plan?

Answer:

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.

Download Oracle Database Optimization Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know what are the ways to code efficient transactions?Tell me some reasons of poor performance of query?