Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 29135 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
Can we commit in trigger?
difference between anonymous blocks and sub-programs.
How many postgresql users are there, worldwide?
Explain the steps needed to create the scheduled job?
What do you understand by pl/sql packages?
Can triggers stop a dml statement from executing on a table?
What is sql and how does it work?
Is join same as left join?
what is meant by urlencode and urldocode? : Sql dba
define sql delete statement ? : Sql dba
Why do we need cursor in pl sql?
How does pl sql work?
What is the difference between explicit and implicit cursors in oracle?
What is a schema? How is it useful in sql servers?
Why does sql need a server?
