How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 26990 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Is sql open source?
what are the differences between require and include, include_once and require_once? : Sql dba
What is database white box testing and black box testing?
How to change sql*plus system settings?
Why do we need databases?
What is the difference between having and a where in sql?
what are the differences among rownum, rank and dense_rank? : Sql dba
What are the features of pl sql?
What mean sql?
how can you create an empty table from an existing table? : Sql dba
Which one is faster ienumerable or iqueryable?
What does trigger mean in psychology?
What is the usage of nvl function?
Explain the components of sql?
What is the advantage of index in sql?
