Stored Procedure increases the performance of the applications. Once stored procedures are created, they are compiled and stored in the database.
Stored procedure reduces the traffic between application and database server. Because the application has to send only the stored procedure's name and parameters instead of sending multiple SQL statements.
Stored procedures are reusable and transparent to any applications.
A procedure is always secure. The database administrator can grant permissions to applications that access stored procedures in the database without giving any permission on the database tables.
|Is This Answer Correct ?||0 Yes||0 No|
Is mysql workbench a dbms?
What is an index? How can an index be declared in mysql?
What is mysqli procedural?
How do you stop an access query?
What is the phantom problem?
What are the column comparisons operators?
How do I stop a query in mysql workbench?
How do I uninstall mysql connector?
What is the size of mysql database?
what are the different tables present in mysql? : Mysql dba
What is difference between oracle sql and mysql?
What are the ways in which you can retrieve data in the result set of mysql using php?