Advantages of using Stored Procedures

Below listed are some of the advantages of using Stored Procedures. This is one of the common questions in job interviews. I have conducted lot of interviews and have heard candidates telling mostly only one answer. "Stored procedure is precompiled and hence has faster execution".

Below listed are the ones which you can now talk on and show your technical expertise. :)

• Execution plan retention and reuse
• Encapsulation of business rules and policies
• Application modularization
• Sharing of application logic between applications
• Query parameterization
• Network bandwidth conservation
• Support for automatic execution at system start-up