Why do stored procedures and functions improve performance? - ProProfs Discuss
Menu
SearchAsk a Question+ Ask Question
Advertisement
  1. Programming Language
  2. Pl SQL

Why do stored procedures and functions improve performance?



Asked by Tikamp, Last updated: Apr 14, 2024

+ Answer
Request
Share
Question menu
Vote up Vote down

1 Answer

tikamp

tikamp

tikamp
Tikamp

Answered Mar 22, 2018

They postpone PL/SQL parsing until run time.
They reduce the number of calls to the database and decrease network traffic by bundling commands.
upvote downvote
Reply 

More Pl SQL Questions

Ask Your Own Question
Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader

Email Sent
We have sent an email to your address "" with instructions to reset your password.