Question

in sql which of the following statements about the stored procedures subroutine are correct ​

Answer 1

Stored procedures save CPU resources by re-using previously cached execution plans.

• By employing execution plans that were previously cached, stored procedures conserve CPU resources.
• The stored procedure in SQL Server offers the best performance.
• The execution plan can be cached by SQL Server and used at a later time.
• Although the caching of execution plans for ad hoc SQL queries has much improved with SQL Server 2000, stored procedures continue to be the best handled database objects by the software.
• A stored procedure's ability to reuse compiled and cached query plans is one of its key performance benefits.
• A stored procedure's execution plan is recorded during its initial execution and used for subsequent executions by being cached in the query plan.
• To recompile the cached stored procedure query plans, or recompile the stored procedure, refers to this operation.

For more similar reference

https://brainly.in/question/41174910

https://brainly.in/question/39012288

#SPJ3

Answer 2

The correct answer is stored procedures save CPU resources by re-using previously cached execution plans.

• Stored methods save CPU resources by using previously cached execution plans.

• The best performance is provided by the SQL Server stored procedure.

• SQL Server has the ability to store the execution plan for later use.

• Although SQL Server 2000 significantly enhanced the caching of execution plans for ad hoc SQL queries, stored procedures continue to be the software's best treatment of database objects.

• One of the main performance advantages of a stored procedure is the ability to reuse compiled and cached query plans.

• The initial execution of a stored procedure records the execution plan, which is then cached in the query plan and used for subsequent executions.

• This step is referred to as recompiling the stored procedure or recompiling the cached stored procedure query plans.

To know more, click here:

brainly.in/question/41174910

brainly.in/question/39012288

#SPJ2