To reduce the context switches between the SQL Engine and PL/SQL engine.

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

Question Posted / hrishi

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

Please Help Members By Posting Answers For Below Questions

Describe sql comments?

1012

How delete a row in sql?

974

Mention what are the benefits of pl/sql packages?

1058

How to select all records from the table?

1117

What is delimiter in pl sql?

1038

What is sap sql anywhere?

1049

Is left join faster than join?

1035

Can you do multiple joins in sql?

1021

What is sql resultset?

970

What does joining a thread mean?

1003

How do I view an execution plan in sql?

967

what are the differences between char and nchar? : Sql dba

1097

Why do we use joins in sql?

956

What program will open a mdb file?

948

when is the use of update_statistics command? : Sql dba

1026