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 sql*loader and what is it used for?

1047

What is cursor in pl sql?

1052

What are local and global variables and their differences?

1048

In what condition is it good to disable a trigger?

971

How many subqueries can be nested in a statement?

935

How many sql core licenses do I need?

884

Is sql injection illegal?

964

Mention what pl/sql package consists of?

939

Why use stored procedures?

1020

what is acid property in database? : Sql dba

962

Does truncate require commit?

921

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

896

What is a temp table?

951

How to prepare for oracle pl sql certification?

1012

Why primary key is required?

939