Cred Interview Question | Time

Question

Does the data stored in the stored procedure increase access time or execution time? Explain.

in progress 2
Dhruv2301 55 years 3 Answers 1630 views Great Grand Master 0

Answers ( 3 )

  1. Data Stored in Stored Procedures can be retrieved must faster than data stored in SQL DataBase. Data can be precompiled and stored in-store procedures. This reduces the Time gap between Query.

    • Data Stored in Stored Procedures can be retrieved must faster than data stored in SQL DataBase. Data can be precompiled and stored in-store procedures. This reduces the Time gap between Query and compilation.

  2. A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name,
    which are stored in a relational database management system as a group, so it can be reused and
    shared by multiple programs.
    Data stored in stored procedures can be retrieved much faster than the data stored in SQL database.
    Data can be precompiled and stored in Stored procedures. This reduces the time gap between query
    and compiling as the data has been precompiled and stored in the procedure.

Leave an answer

Browse
Browse