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

Define select, insert, create, delete, update, drop keywords

1094

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1226

What is the difference between drop and truncate commands?

1110

What is the default isolation level in sql server? : Transact sql

1081

What is rename command in sql?

1093

What is sql keyword?

1043

What is the file extension for sql database?

1062

What is dml statement?

999

In a distributed database system, can we execute two queries simultaneously?

1153

What is lexical units in pl sql?

1206

what is self-join? : Sql dba

1239

Can a varchar be a primary key?

1047

What is delete command in sql?

1173

What is multiple columns?

1116

how to use myisamchk to check or repair myisam tables? : Sql dba

1016