Stored Procedure Question: Download Questions PDF
Does storing of data in stored procedures increase the access time? Explain?
Answer:
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.
Download Stored Procedure Interview Questions And Answers
PDF
| Previous Question | Next Question |
| State about the security aspects of stored procedures? | Explain about the difficulties faced by the database developer in implementing pre compiled statements? |