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 date and time data types in mysql? : Sql dba

916

how to convert numeric values to character strings? : Sql dba

1034

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1018

What is a full join sql?

980

What is sqlca in powerbuilder?

953

How many columns should be in an index?

901

what is the difference between inner and outer join? Explain with example. : Sql dba

970

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

How do you rank data in sql?

933

what is self-join? : Sql dba

1050

How to start the command-line sql*plus?

996

How can you load multi line records? : aql loader

1018

what is auto increment? : Sql dba

960

What does (+) mean in sql joins?

1006

How many clustered indexes can you have?

924