Tutorial Importance Of Stored Procedures


Well-Known Member
Stored Procedure is a subroutine available to be used by applications or system that access a Relational Database Management System (RDMS). They are stored in the database and may contain one or more SQL queries in them.

Here are some of the list on how important Stored Procedure is.
  • Compiled once and can only be access by an executable form, so this makes them quick and efficient
  • Automatically cached and shared to all the users.
  • Has lower memory requirements
  • Can call multiple queries
  • Allows you to use the computing resources of the server
  • Avoid redundant coding or recycling
  • Can be maintained and enhanced easily the developer