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 are the security recommendations while using mysql? : Sql dba

1177

How do I count duplicates in sql?

1176

How do I clear the screen in sql plus?

1086

what are the different type of normalization? : Sql dba

1067

Why is %isopen always false for an implicit cursor?

1151

How to prepare for oracle pl sql certification?

1107

What are primary key and foreign key and how they work?

1016

What is full form of rtm?

1051

Is and as keyword in pl sql?

1012

What is the difference between between and in condition operators?

1066

what is row? : Sql dba

1276

Does inner join remove duplicates?

996

What are the different types of database management systems?

1036

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1048

How to rename a table?

1074