Stored Procedure Interview Question:

Does storing of data in stored procedures increase the access time? Explain?

Submitted by: Administrator

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. To avoid repetitive nature of the data base statement caches are used.
Submitted by: Administrator