How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Answer Posted / hrishi

To reduce the context switches between the SQL Engine and
PL/SQL engine. We can use Bulk Bind Concept to this...

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of sqlerrd 3?

522


explain commit and rollback in mysql : sql dba

549


Why are aggregate functions called so?

517


Is sqlite thread safe?

609


What is mutating error in pl sql?

553






How do I run a sql query?

533


What is rtm stands for?

585


What is crud diagram?

515


How subquery works in sql?

544


Can we use pl sql in mysql?

519


How do I save the results of sql query in a file?

535


Where is all the data on the internet stored?

558


Is postgresql a server?

577


What has stored procedures in sql and how we can use it?

571


What is the difference between instead of trigger and after trigger?

514