What are advantages of Stored Procedures?

Answer Posted / greatasoft-mani.b

Stored Procedure's are precomplied one. When ever you call
a stored procedure it generate the result faster than
ordinay coding. The improve the performance of the
application i.e to reduce the time stored procedure's are
used

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a native sql query?

496


how many values can the set function of mysql take? : Sql dba

532


Cite the differences between execution of triggers and stored procedures?

624


What is the maximum number of rows in sql table?

551


What are pl sql procedures?

518






Do ddl statements need commit?

540


How do I view an execution plan in sql?

531


What is sql and how does it work?

551


Where do we use pl sql?

555


What is a trigger in sql?

642


What is difference between my sql and sql?

531


what are myisam tables? : Sql dba

552


what is a cursor? : Sql dba

557


Does pl sql work in mysql?

536


Which query operators in sql is used for pattern matching?

546