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 all the common sql function? : Sql dba

1058

What is rank dense_rank and partition in sql?

1042

what is msql? : Sql dba

988

how many sql ddl commands are supported by 'mysql'? : Sql dba

1023

what is the difference between truncate and drop statements? : Sql dba

1126

how to get help information from the server? : Sql dba

941

What is mutating trigger?

1023

What is difference between sql and mysql?

1133

What is cross join sql?

917

Can we create table inside stored procedure?

955

What is faster join or subquery?

1011

How to run pl sql program in mysql?

1020

Can sql developer connect to db2?

1053

How delete all data from table in sql?

1019

what is the syntax used for partition in tsql? : Transact sql

1014