which one performs better a simple stored procedure or the same procedure in a package.And Why?
Printable View
which one performs better a simple stored procedure or the same procedure in a package.And Why?
There will be no difference between the both.
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
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 ..