Oracle DB Optimization Question:
Download Job Interview Questions and Answers 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.
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 Question | Next Question |
| Do you know what are the ways to code efficient transactions? | Tell me some reasons of poor performance of query? |