How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
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
where are cookies actually stored on the hard disk? : Sql dba
what is bdb (berkeleydb)? : Sql dba
What is the command used to fetch first 5 characters of the string?
What are different categories of sql commands?
Cite the differences between execution of triggers and stored procedures?
How does cross join work?
What do you understand by case manipulation functions?
What sql database should I use?
Does google use sql?
How to prepare for oracle pl sql certification?
What is procedure explain with program?
What is trigger and stored procedure in sql?
How can we find duplicate records in a table?
how many columns can be used for creating index? : Sql dba
Which kind of parameters cannot have a default value in pl sql?