Why are stored procedures used?



Why are stored procedures used?..

Answer / Gaurav Agarwal

"Stored Procedures in PostgreSQL are used to encapsulate SQL code, parameters, and transaction control for reusable program modules. They help improve performance by reducing network traffic by storing the code on the server."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

How to create table with timestamp in postgres?

1 Answers  


What is a delete query?

1 Answers  


What is the advantage of postgresql?

1 Answers  


Is postgres a mpp?

1 Answers  


How do you insert rows and columns?

1 Answers  


How will you add a new style in a table?

1 Answers  


How to execute a function in postgresql?

1 Answers  


What port does postgresql listen on?

1 Answers  


What are indexes in postgresql?

1 Answers  


Explain multi version concurrency control.

1 Answers  


Explain about functions in PostgreSQL?

1 Answers  


Is postgresql is nosql?

1 Answers  


Categories