Q 1. Due to which of the following reasons, insertion of data through stored procedure helps to reduce network traffic and increase database performance?
The source is compiled into an execution plan when executed for the first time. When executed again, before the execution plan is aged from memory, the SQL Server engine detects the existing plan and reuses it.
Which of the following terms is related to this information?