-
Junior Member
PL/SQl
which one performs better a simple stored procedure or the same procedure in a package.And Why?
-
Re: PL/SQl
There will be no difference between the both.
-
Expert Member
Re: PL/SQl
Yes as debasisdas said no difference in performance. But it is a good practice to include all your logically related procedure and functions in single package.
Advantage of this practice is whenever a procedure or function of a package is called the entire package is getting loaded in to main memory. Definitely it is a performance effective since possibility of calling other procedures or functions is more.
Hope this helps you
-
Junior Member
Re: PL/SQl
hello friends i am govind . i am a new subscriber of this site . help me to use this site . how to ask questions through this site . i am so much confusing to choose my carrier . so i need your suggestion ..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules