Benefits of Stored Procedures
Fill In The Blank
Views 458
Answer:
- Reduced: Stored procedures have to be executed only once and the execution code can be used again later. In this way, it impacts the final performance when you have to call the same procedure multiple times within a database application.
- Programming: It helps in cutting down the size of the code and it can be transmitted over the network quickly. Ultimately, network traffic will reduce significantly.
- Effective: The best thing is that one stored procedure can be accessed by multiple users at once. It results in the reduced development cycle and enhances the performance.
- Enhanced: Every time when you are executing a stored procedure, certain permissions can be defined that enhances the security controls.
Related Articles:
This section is dedicated exclusively to Questions & Answers. For an in-depth exploration of SQL, click the links and dive deeper into this subject.
Join Our telegram group to ask Questions
Click below button to join our groups.