1)by using index 2)by using bulk collect 3)by using exist operator 4)by

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

Question Posted / anand reddy

Answer Posted / anand reddy

1)by using index
2)by using bulk collect
3)by using exist operator
4)by using hints
5)by using nocopy option
6)by using collection types

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is coalesce sql?

695

What is sql key?

689

what is online transaction processing (oltp)? : Sql dba

713

Can we commit inside a trigger?

732

What are the two different parts of the pl/sql packages?

789

Does pl/sql support create command?

743

what is union, minus and interact commands? : Sql dba

860

What is a sql trace file?

740

How to know the last executed procedure?

809

How do you sort in sql?

774

What are joins in sql?

719

how to include comments in sql statements? : Sql dba

723

What is scalar data type in pl sql?

786

How do I write a sql query in pgadmin 4?

712

Difference between global and parameter variables?

1656