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

Where is sql database stored?

961

Why do we use partitions in sql?

1032

Can we insert delete data in view?

935

What does the sign mean in sql?

967

How subquery works in sql?

1052

Is merge a dml statement?

953

What is a temporal data type?

1026

How do I partition a table in sql?

1104

What is the difference between a primary key and a clustered index?

969

What is the cause of mutating table error and how can we solve it?

1035

what are the different tables present in mysql? : Sql dba

957

What is rank dense_rank and partition in sql?

1006

What is sql deadlock?

1113

What is the use of nvl function?

1175

what are the different type of sql's statements ? : Sql dba

904