By using Indexs we can improve the performace, also use exist and not exis

How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Question Posted / dipti

Answer Posted / dipti

By using Indexs we can improve the performace,
also use exist and not exist in place of in and not in as
it plays the same role as Index.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the advantages and disadvantages of views in a database? : Sql dba

993

Where not exists in sql?

904

What is difference between sql function and stored procedure?

934

What is the primary key?

876

How global cursor can be declare with dynamic trigger ?

2143

How do I save a sql query?

961

Why use subqueries instead of joins?

1028

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1063

What is the difference between delete and truncate statement in sql?

1006

What is dcl in sql?

903

explain advantages of myisam over innodb? : Sql dba

1014

What is meant by <> in sql?

889

Is primary key clustered index?

893

How to add new employee details in an employee_details table with the following details

1039

Which one is better sql or oracle?

898