Storing of data in stored procedures increase access time

Illustrates storing of data in stored procedures increase the access time?

E

Expert

Verified

Data stored within stored procedures can be retrieved much faster than the data stored inside SQL database. So, Data can be precompiled and stored in stored procedures. Such reduces the time gap among query and compiling as the data has been precompiled and stored inside the procedure. To ignore repetitive nature of the data base statement caches are utilized.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.