How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 26985 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / shailesh
We can improve the performance by create indexes on the use
tables which is used in the procedure,function and packages
And with the help of these indexes we can improve the
performance.
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Explain the uses of database trigger.
What is a clob in sql?
How do you determine the current isolation level? : Transact sql
What are tables and fields?
How many triggers can be applied to a table?
What is the sql*loader? : aql loader
What are aggregate and scalar functions?
what is the difference between blob and text? : Sql dba
How do you rank data in sql?
Can we commit inside a trigger?
What is the main difference between sql and pl/sql?
What are few of the schema objects that are created using PL/SQL?
What is the maximum rows in csv?
what is recursive stored procedure? : Sql dba
What is having clause in sql?
