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.
| Previous Question | Next Question |
| Do you know what are the ways to code efficient transactions? | Tell me some reasons of poor performance of query? |