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
- 29637 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 myisam tables? : Sql dba
What are the advantages of sql?
What does truncate mean in sql?
How do I run a pl sql procedure in sql developer?
Why do we need view in sql?
What is dcl in sql?
How do you write an inner join query?
What is meaning of <> in sql?
how to get a list of indexes of an existing table? : Sql dba
Why commit is not used in triggers?
What is record type in pl sql?
What is normalisation in sql?
What is the use of sqldataadapter?
Show how functions and procedures are called in a pl/sql block.
Is primary key clustered or nonclustered?
