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
- 28796 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / bala
By avoiding sql statements & select INTO kind of statements.
To improve better creating cursors to hold data.
Indexing is the way to tune the database tables.
so, mostly try to avoid Hard Coding in the select
statements..
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is the difference between joins?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How do I find duplicates in two columns?
What are different types of statements supported by sql?
What does select top 1 do in sql?
What is date functions?
What does sign mean sql?
Can we call dml statement in function?
what is transaction? : Sql dba
how to drop an existing index in mysql? : Sql dba
How bulk collect improves performance?
Can two tables have same primary key?
how does a local variable is defined using t-sql? : Transact sql
What is raid? How does it help storage of databases?
what is clause? : Sql dba
