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
- 29259 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
What are %type and %rowtype for?
How do you remove duplicate records from a table?
How do I run a sql script?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Why should I use postgresql?
What is case function?
what is the functionality of the function htmlentities? : Sql dba
How do sql triggers work?
What is rename command in sql?
How do you update a sql procedure?
What view means?
How do I sort a table in sql?
What is the difference between mdf and ndf files?
How to run sql statements through the web interface?
What's the difference between a primary key and a clustered index?
