How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 24215 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
Does sql profiler affect performance?
How do I install microsoft sql?
What is row_number () in sql?
What is denormalization in a database?
Define concurrency control. : Transact sql
what is the use of double ampersand (&&) in sql queries?
what is subquery? : Sql dba
What are different joins used in sql?
Explain clause in sql?
Write a sql query to find the names of employees that begin with ‘a’?
how to drop an existing index in mysql? : Sql dba
How is pl sql different from sql?
Why is there a need for sqlcode and sqlerrm variables?
what is the difference between char_length and length? : Sql dba
Why do we use sql constraints?
